Summarizing a Report

  • Thread starter Thread starter Cubbie
  • Start date Start date
C

Cubbie

I have a database linked to an excel file for the table. The excel file
contains the results for a school archery tournament. Each school is allowed
to have 24 archers but only the top 12 count as a team score and 4 must be
male and 4 must be female. My report works fine giving me the top 12 and a
team total for each school and division, but it does not ensure the gender
ratio is met. Any ideas??

Also, I would like to create a report that shows just the schools and team
totals, but the only place I currently have team totals is in a report.
 
You want three queries. Query A gets you the top 4 Female scorers. Query
B gets you the top 4 Male scorers and query C gets you the top four scorers
not in query A of B results.

Regards

Kevin
 
Back
Top