Summarizing a Report

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.
 
K

kc-mass

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pull out certain data 1
Database 1
IIF in a report Footer 3
Best way to print totals 2
counting problem in report 2
Creating a report from a query using drop down box parameters 1
Report Setup 3
How to group my student data using Excel 2

Top