Page numbers in a report independently for each record

  • Thread starter Thread starter Jari V. K.
  • Start date Start date
J

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--
 
Jari said:
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.
Click to expand...


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
 
Back
Top