Windows 7 32bit 
Access 2010 32bit
I have 16 different reports for 16 different teams. The record source for each report is a query for each team . Each query refers to one huge student list that contains information about which sport the student plays, nationality, grade, address, etc. With 16 teams this method is still manageable, however I am thinking that there must be a better and easier way. These team rosters are like class lists for teachers in a school. In a big school of 50 to 100 classes, I can't imagine having to create a separate report and query for each class. Is there a way I can have 1 report which when run/opened (being new to access I don't know the terminology), will prompt me to enter team (eg. high school boys basketball) and also can retrieve the info straight from the main student data base, rather than having a separate query for each sport?
Reply With Quote
