Ranking list

[yalebulldog]

Not sure this is the correct area for this question, anyway here it is, please HELP!!!

I have records in one database (rosters) that is sorted by a field called "sport." Every record has a name(athlete) and their sport. Each athlete is given a rank from 1-20 (20 being the maximum for this particular report). So what I want to do is a print a report that does a find/sort based on sport(got that part), then sort based on the rank given to them. Note: not all sports will have 20 athletes at the time of reporting, but needs to show all 20 variable in order 1,2,3...., even if rank #4 is blank. This is either very complicated or so simple I can see it. Thanks for the help.

[FUBAR]

Easiest fix (that I can think of off the top of my head) would be to create 20 records for each sport (since 20 is the maximum for your report) and leave the athlete names blank if there are less than 20 athletes.

If after you do this, you want to print a report of a number smaller than 20, then you would need to use a relationship (again first idea I have)

Hope this helps