Top 20

  • Thread starter Thread starter LG
  • Start date Start date
L

LG

I have db that I created a query to choose the top 20 members with the most
activity. How do I go about printing out all the info associated with the
top 20. Ex. member 1234 has 500 lines of activity how do I get that for all
the top 20? Do I have to build another query with a relationship of 1 to 1?
 
If you have one query that returns the (*top 20*) list you want, you can
create a second query, based on the first, and joined to the table that has
your "lines of activity" per member. You should get the lines of activity
for each of the 20 members.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top