I am new here and have inherited a database that I am trying to generate a very large report from. The MainTable has seven lookup fields in it. I have built tables to represent each of these fields.
The report I need to compile will basically have the following information:
Spelling Bee: # wins at school level, # wins at regional level, # wins at state level (lookup choices are win, lose, tie for each level)
Track: # wins at school level, # wins at regional level, # wins at state level (lookup choices are win, lose, tie for each level)
Soccer: # wins at school level, # wins at regional level, # wins at state level (lookup choices are win, lose, tie for each level)
All Sports: # of losses and ties
Each of these activities are in a lookup field, and each of these win levels are in a lookup field. In order to get this information into a single report, will I need to run multiple queries, count the results, and have the report show the results? If I do it this way, will all the queries run and refresh each time I pull the report? Ultimately, all these individual results are to be transferred to an excel spreadsheet.
Thank you for any thoughts/advice. I think I am in over my head on this one.......