page # for a filtered batch report

[6ommer]

I have a batch report which group multiple reports by using

DoCmd.OpenReport GetDBReportName(), acViewPreview, , strTmp

and pass in strTmp ="orderID in ('q120120,q120121')"

The only thing I have trouble is the page by each ID.

For instance, The batch has two reports, ID=123 has 2 pages, ID=456 has 1. All 3 pages come out at the same time, but the page header will show 1/2, 2/2, 1/1 on each page assuming ID=123 is the first one. Or 1/1, 1/2, 2/2 if ID=123 is the 2nd one.

I have trouble particularly getting the 2 from the 1/2. At the moment, I had [page]= 1 or 2, and [Pages]=3, but there seems no way I could hook into the total page of 2 for ID=123.

I am looking an event that when access gets the total number of pages (3), I could get a page count by group.

Thanks!

 

[THWatson]

Check in Help for "reset page number for each group in a report" and see if that does what you want.

Tom