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!