Thanks for your help and guidance.  I have set up database for 700 member POA.  I am now working on the golf course details.  In doing so I am prepairng a golf handicap system.  All numbers are in place.  Handicap is based on the best 10 of the last 20 scores.  I have all that data established in database.  My problem is I must determine what the last 20 scores of each individual.  So, I must do this by date and I can find no function to return the last 20 dates.  Please help.  When I solve this problem I can use the Top values to determine the best 10 scores.  Thanks again for your great tutorials and especially your teaching methods.   Dave Thomas

---

Reply from Richard Rost:

You can also use the TOP feature to find the last 20 scores. Just create one query where you find the TOP 20 values based on DATE. That will be the most recent 20 scores. Then feed those results into ANOTHER query where you use the TOP value on the SCORE instead.