|
MaxQueryProblem.mdb (beginner) |
||||
Please consider donating $1 per sample downloaded, find out why here |
Download MaxQueryProblem.zip Access 97 (50 KB) |
The Problem: You want to create a query which will return a MAX Date and the corresponding Amount, grouping them on the Customer Name. It shows why you should not use two aggregate functions (like MAX) in a query, and two different ways to solve the problem correctly. |
||||
|
|||||
|
|||||