Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem with aggregate
Hi, I get an error message (cannot have aggregate function in where clause MA_V.ABDAT = MAX(MA_A.ABDAT) AND MA_V.MAN = MA_A.MAN) when I try to execute a query created in MS_SQL. I've tried to modify the query but always got an error. Maybe is it too simple but I don't see the solution. Here is...- Manneke
- Thread
- Replies: 5
- Forum: Microsoft: Access Other topics
-
Problem in running a query with linked table
Hi everyone, Here is my problem. I run a query which works on some PC's but not all. Doesn't matter which version of Access I use. This query uses a MS_SQL linked table and is integrated in a Crystal report. This report is integrated in another application which uses a crystal report runtime...- Manneke
- Thread
- Replies: 4
- Forum: Microsoft: Access Other topics
