multiple reports in Access

Hi firstly thanks iwells for the last very helpful advice you provided.
Does anyone know how to run more than 1 report from Access (so more than 1 records) at one time?

1. Is this the same report with different records from the same query or recordset?
2. Or are these different reports using the same record.
3. Lastly is this a different report with a different record set?

lwells

Hi iwells,

Its the same report with different records from the same query or recordset.

So students have had a subject test and a report for the test needs to be generated for each student in the database that has had a test.

Why don't you create 1 main report and 1 sub-report for each student?

Hi Raje,

What you could do is loop through your recordset and then print a report on each record before moving to the next record. Or if your query has the range of students in which you want to make individual reports on, then set your report to display one page per student and when you run your print report it will print all the students, one per page.

Just depends on your report layout that you are using, or the way your query criteria is set up as to which method will work best for you.

lwells

How would you create this loop? My form is using a query to bring up results, I need these results printed out one at a time on the same report template. So 100 results would print out 100 seperate reports..

many thanks,
pete.

Set your report to group by usually the ID number. This will give you one report for each record from your query results. If you are changing the query criteria, then rerun your query to refresh the records and print your reports from the changed query.

lwells