I designed an access db that collects data on our archery match - 200 archers. I have a shooters table to account for the individual scores from 5 different individual events. My reports are filtered to display descending scores for each event. Then I have a report to show combined scores for all 5 events with descending scores... (highest score best). We also have team events. Each team is made up of 4 shooters. My team table is linked to my shooter table and tells me the scores from each team event there are two team events - but... and here is my problem. I need the best team report to show the sum of each of the shooters individual events plus the team events to give me a sorted Best Team report sorted highest to lowest. I have tinkered with this with calculated fields but the calculated fields in the report will not sort at all.
So I'm thinking my base design is wrong.
I know this is a lot to digest, but any advise would be appreciated.
Thanks, Wayne
So I'm thinking my base design is wrong.
I know this is a lot to digest, but any advise would be appreciated.
Thanks, Wayne