General discussion
-
Topic
-
Access Database Query Problem
LockedIn a query with multiple groupings, Access seems to lose specificity. Specifically, table structure – ID, Test Type, Test, Test Date, and Score. Group by ID, Test Type, Test, and Max(Test Date) in a totals query, but can’t get score for that date and specific test in the same query. I’ve tried aggregate functions too, but constantly find myself getting error messages. I can do it as two queries, but it would greatly simplify my life if there was a way to do it all in one.