Page numbering in footer (Page # of #)

[EA]

I have a monthly productivity report that I print for a list of staff members
and the report content is fine. However, some employees have multiple pages
and I have to indicate page numberings at the footer (i.e., Page 1 of 7,
etc...). The problem is that Access will indicate the total number of pages
for all employees, so instead of John Doe's report showing 'Page 1 of 7' it
shows 'Page 1 of 357'.

Does anyone know a way so to have this report display the 'Page 1 of 7'
format?

Thanks in advance!

 

[fredg]

I have a monthly productivity report that I print for a list of staff members
and the report content is fine. However, some employees have multiple pages
and I have to indicate page numberings at the footer (i.e., Page 1 of 7,
etc...). The problem is that Access will indicate the total number of pages
for all employees, so instead of John Doe's report showing 'Page 1 of 7' it
shows 'Page 1 of 357'.

Does anyone know a way so to have this report display the 'Page 1 of 7'
format?

Thanks in advance!

See:
"Printing First and Last Page Numbers for Report Groups "
http://www.mvps.org/access/reports/rpt0013.htm