[AccessD] How to Reset Total Pages Number on Report

I seem to recall there being an example of this in one of the sample
database, probably Solutions.  Depending on the version of  Access
you're using, it my be on the Office CD or downloadable from Microsoft.

Charlotte Foust

-----Original Message-----
From: Billy Pang [mailto:tuxedo_man at hotmail.com] 
Sent: Wednesday, February 19, 2003 5:34 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] How to Reset Total Pages Number on Report


Hello:

I have a report that displays invoice details by client.
For each invoice there may be multiple pages.
How do I make it so that it diplays X of Y pages for each client?

For example, if there are a total of 3 pages in my report where the
first 
page belongs to Client A and the next two pages belong to Client B, then
I 
want the following page numbers on the bottom of Access report:

Page 1 of 1
Page 1 of 2
Page 2 of 2

I have gotten as far as resetting the page property back to 1 using the 
OnFormat event on my first grouping but I cannot seem to do anything
with 
the [PAGES] property (it is read-only).

Thanks in advance,
Billy




_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com