Extremely Difficult Query (1 Viewer)

R

rajdas

Guest
I have a table with 1700 records. Each product(field products) belongs to a product group(field prgroup). How can I print a report showing me the top 5 products sold for each product group. Quantity field is called (qty).

Thanx in advance
 

Chris RR

Registered User.
Local time
Today, 05:04
Joined
Mar 2, 2000
Messages
354
What you need to do is to create a "TopValues" query (look this up in Access help). Get that working, and then build your report on that. 17 or 1700 or 170,000 records, same process.
 

Users who are viewing this thread

Top Bottom