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.

 

Feedback

 

Need Winzip?

Return to Main Page