Novice
Windows XP 
Access 2007
Looping through a report with subreports.
I have a report with three sub-reports inside of it. Currently when it opens, it asks for a US State, then based on what State the user types in, it runs the report ans sub-reports for that state. What I want to do is somehow, with one click, generate the reports for all 50 states at once. Eliminating the need for the user to have to type in one at a time. Any help would be appreciated.
Access Developer
Windows XP Access 2003
Can you show us the SQL of the query on which the main report is based.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Display sequential row numbers within one report that has multiple subreports
Posting Permissions
Reply With Quote