Top 3 Query Help

[Guest]

Can someone help me with this query?

What are your friend’s top three favorite artists? Query should only return
3 artists.

 

[Allen Browne]

In query design view, open the Properties box. Looking at the properties of
the query (not of a field), set the Top Values property to 3. Then sort the
query such that the favorite artists are at the top.

If you have multiple friends in the query, and you with the top 3 artists
for each of them (not just the top 3 overall), use a subquery. Details in:
Subquery basics: TOP n records per group
at:
http://allenbrowne.com/subquery-01.html#TopN