Page 1 of page 3 BY GROUP (Access 97 SR-2)

Topic

New Reply

Is it possible to print at the bottom of each page “Page __ of __ ” where the value refer to the grouped section (in this case, by SSN), rather than for the entire collection of all pages?

Any help would be appreciated.

Thanks,
Sean

Reply | Quote

Replies

I don’t think this is possible. At least I’ve never seen how it can be done. I thought I could do it with a subreport, but neither the Page nor Pages property works with a subreport. The only thing I can suggest is to create a routine that call the routine continually, once for each of your “groups”, include that group in a WHERE clause within the OPenReport method.

Reply | Quote

I’ve not tried to set the total number of pages this way, but you can set the OnFormat command of the page header to reset the PAGE number, so each section or group starts with 1. You can do it either with a macro or with VBA.

Reply | Quote

>>I’ve not tried to set the total number of pages this way, but you can set the OnFormat command of the page header to reset the PAGE number, so each section or group starts with 1. <<

Setting the Page number is no problem. However, you can't set the PAGES property; it is read-only and is the total number of pages in the report. So, you can determine how many pages in a section in order to be able to be able to number pages: 1 of 2, 2 of 2, 1 of 3, etc.

Reply | Quote

The solution is in redimentioning pages. Go to the access web. There is a solution. But i have not tried it.
http://www.mvps.org/access/reports/rpt0013.htm

hth Richard

Reply | Quote

Richard,

Thanks. I checked it out, and it certainly is an interesting concept. I’ll have to study it more at length (it’s a little deep to take it all in on just 1 reading!).

Reply | Quote

Sean: Try this link

http://www.mvps.org/access/reports/index.htm

Scroll down to ” Printing First and Last Page Numbers for Report Groups”. I have used it and it works. I think it is what you want. Do read it carefully as it is intense. HTH.

Reply | Quote

This is quite possible. Besides the solution offered, there is also a MSKB article with a similar solution, but it uses a table rather then an array to store the page numbers.

It boils down to forcing the report engine into 2 passes, the first is used to pickup the pages, the 2nd to format a control with the number.

Jim.

Reply | Quote