top 5 for multiple sets of data based on criteria

[Guest]

I need help. I have a simple table in which each row represents a sales, and
which includes fields for state and id#. I need to generate a query that
displays the top 5 for the most sales by id#'s by state.

I have found it easy to count the number of sales by id# and state, or to
query for the top 5 for a given state, but cannot figure out how to query for
the top 5 for EACH state.

I am supposing that I need to nest an expression in my SQL statement (or
design view), but cannot seem to make it work.

Thanks in advance for any help

 

[Van T. Dinh]

See the Microsoft Knowledge Base articles:

http://support.microsoft.com/?id=210039

and

http://support.microsoft.com/?id=208822

HTH
Van T. Dinh
MVP (Access)