Resetting &Pages after group

[Leeeon]

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

 

[PaulBricker]

Look at this site. It should give you what you need.

Paul

http://www.mvps.org/access/reports/rpt0013.htm

 

[Leeeon]

Cheers. That worked perfectly.

LeonH