Selecting Top Records

[thingssocomplex]

Hi All,

I would like to write one query that would allow me to select the top 5 records by a group type, for example

Group1
Gourp2
Group3

I would like to write the query so the TOP 5 records for each of the above groups are displayed in one query set so I would have 15 entries in total sorted in DESC order on value.

Is this possible or do I have to write 3 seperate queiries and amend each to a table to display the 15 records?

Any help is gratefully appreciated

 

[G81]

Change to sql view in your query and use a union to join your 3 select queries together (using top 5 for each)

http://www.fabalou.com/Access/Queries/unionquery.asp