Page and total for group by report

Hi there,
I make a report that allow to print all the chemicals that one professor have in all his lab rooms. I have the total chemicals that he has. I group by location (lab rooms)
what I want to do now is
1. Calculate how many chemicals in one location (lab room) and it can appear in the report.
2. For a another location (another lab that this professor is supervise) the report should be in a new page of this report.

I do not know how to calculate for each location and set up the pape. Please help if you have any suggestions.
Thank you for your continued help,
Regards,
Le Tran

Group your report by Professor and Location
Have a footer for Location
In the footer for the Location put your count expression and also a page
break

HTH
"Le Tran" wrote in message
...
Hi there,
I make a report that allow to print all the chemicals that one professor
have in all his lab rooms. I have the total chemicals that he has. I group
by location (lab rooms)
what I want to do now is
1. Calculate how many chemicals in one location (lab room) and it can
appear in the report.
2. For a another location (another lab that this professor is supervise)
the report should be in a new page of this report.

I do not know how to calculate for each location and set up the pape.
Please help if you have any suggestions.
Thank you for your continued help,
Regards,
Le Tran