Page numbers in a report independently for each record

[Jari V. K.]

Hi!



I need your advice in this kind on page numbers issue. My report will print
about 300 records. Most of the records will need two pages but some of them
only one. What I need is a page number in the page header that is
independent for each record like rec. #1 à 1/2 , 2/2 rec. #2 ½, 2/2 rec. #3
1/1 rec. #4 1/2, 2/2 and so on. Currently page numbers are printed like
1/542, 2/542, 3/542, 4/542 and so on.



I found an article http://www.mvps.org/access/reports/rpt0013.htm explaining
a grouping solution, but this is not what I need because there is no
grouping in my report.



--Jari--

 

[Marshall Barton]

I need your advice in this kind on page numbers issue. My report will print
about 300 records. Most of the records will need two pages but some of them
only one. What I need is a page number in the page header that is
independent for each record like rec. #1 à 1/2 , 2/2 rec. #2 ½, 2/2 rec. #3
1/1 rec. #4 1/2, 2/2 and so on. Currently page numbers are printed like
1/542, 2/542, 3/542, 4/542 and so on.

I found an article http://www.mvps.org/access/reports/rpt0013.htm explaining
a grouping solution, but this is not what I need because there is no
grouping in my report.

You can still use the technique explained in that article.

Either use the Detail section where ever the article talks
about group, except use the record's PK field instead of the
group name (Salesperson). Or you could create a grouping on
the PK field and follow the article as stated.

For a slightly different approach, see this article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;306127&Product=acc