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

Download the RptSamp from MS there are examples

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.