Is this possible..Top 10 by date range (2 Viewers)

[mreference]

I have a query with a few fields

[OrderDate] [SKU] [QuantityPurchased] [RangeName] [Category]

I am trying to create a filtered form that would prompt the user for a start / end date, then the top 10 best sellers would be displayed

Once created, I want to then add in a few other filters based on [RangeName] [Category] so the results will display the top sellers within the selections made.

I have searched around the forum and internet but I'm not getting anything like the results I need.

Any help would be appreciated.

 

[theDBguy]

Have you tried looking up Top N Per Group?

 

[mreference]

Have you tried looking up Top N Per Group?

I have seen helpful threads on this but nothing that allows me to add in a date range. I'm sure it can be done.

 

[theDBguy]

I have seen helpful threads on this but nothing that allows me to add in a date range. I'm sure it can be done.

It might help us help you if you could post a sample db with test data.

 

[isladogs]

An easy way is to do this in two queries
1. Filter by your date range and save as e.g. Q1
2. Now create a TOP 10 query based on Q1

If you want to do this in one query, you will need to use a subquery
See Allen Browne's article Microsoft Access tips: Subquery basics (allenbrowne.com)

 

[mreference]

Thank you, the two queries worked a charm.

 

[theDBguy]

Thank you, the two queries worked a charm.

Hi. Glad to hear you got it sorted out. Good luck with your project.