I have a report that prints information grouped on different departments. At the bottom of each page I have the standard 'Page 1 of 20' footer using &Page and &Pages.
For each group I would like to be able to print the number of pages for just that group and then reset it for the next group eg
For a 15 page report, first group may be pages 1-4 so I want 1 of 4, 2 of 4 etc printed. Second group may be pages 5-15, so I want 1 of 11, 2 of 11 etc.
I can reset the &Page number by putting Page = 1 in the OnFormat event but can't figure out how to get the &Pages values.
Thanks
LeonH
For each group I would like to be able to print the number of pages for just that group and then reset it for the next group eg
For a 15 page report, first group may be pages 1-4 so I want 1 of 4, 2 of 4 etc printed. Second group may be pages 5-15, so I want 1 of 11, 2 of 11 etc.
I can reset the &Page number by putting Page = 1 in the OnFormat event but can't figure out how to get the &Pages values.
Thanks
LeonH