I'm not sure if you can do this in design mode. But for sure with some codes
you can achieve this. Assign the RecordSource to the report through the code
and make sure the recordsource is a parameter query. The parameter will be
the group ID (the Department Code). 
In the main code, where you're calling the report to print, you will
maintain a loop which will pass the  department Codes to the query, then you
will refresh the recordset and assign the recordset to the report
Recordsource. I hope it's not confusing. The idea here is that, in one cycle
of the loop only one department will print.The page number and the number of
pages will print the way wanted.

-----Original Message-----
From: Rowenap@w... [mailto:Rowenap@w...]
Sent: Thursday, August 17, 2000 9:01 PM
To: professional vb
Subject: [pro_vb] how would you show the total number of pages 


-----Original Message-----
From: Rafik [mailto:ryan1@o...]
Sent: 04 August 2000 21:45
To: support@w...
Subject: page of pages


Dear Sir,

Thank you for an interesting book (Beginning Access 97 VBA Programming ISBN 
1-861000-86-3)
I wonder if you could expand over the subject of "Page of Pages" (Your page 
No 260).
My question is : how would you show the total number of pages per group 
(rather than per whole report) as well as the current page number?
i.e. Invoices Report grouped per department where one department receives a 
4 pages invoice (page 1 of 4), another department 6 pages (page 1 of 6) 
etc...
your help would be very appreciated.

Many Thanks.
Ryan Kirby.