league table

G

Gilbo

I have a league table that works fine, but I need to attach a position field
(1 to 12) to it, that updates every time the positions move. Any help would
be appriecated.
Thanks
Gilbo
 
D

David F Cox

use the DCount function to find out how many records have a higher ranking,
and add 1 to get the league position.
 
Top