Access Report Pagination
Posted on 2009-04-16
I am printing a lab report that contains many 1, 2 or 3 page reports to different people.
I am using a group header for their property address (1 per person)
In the VBA code for the group header I am setting Page = 1 to begin each persons report at page 1.
I would like to use the "of" page number function. (Page 1 of 2)
But the "of" number is the number of pages in the entire report for everyone. (Page 1 of 63 for example)
Is there a way to calculate the "of number" for each group?
What is the syntax for that command?
Thank you in advance for your help.