How do I create a query in Access that shows the highest three nu.

[carmel]

How do I in Access query get the highest 3 numbers within each group?

 

[Allen Browne]

See:
ACC2000: How to Create a "Top N Values Per Group" Query
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;210039