Top Ten 1

[1starr]

I need to create a quert that gives me the top 10 most sold item in each store. In other words I have approximately 8 stores that and I want only to find out what items are most popular in each location and with this query I will create a report showing by location what was the 10 most sold item in each location.

 

[lespaul]

The easy answer is:

In your query: SELECT TOP 10

for a more detailed answer please provide information regarding your table(s) structure, sample data, and expected results.

 

[markgrizzle]

LesPaul's answer will only return the top ten records. If 1starr needs top ten per store, create a separate totals query for each store, group by item, sort by item and descending sales. Set the Top value to 10, then use a union query to display store results together.