adding an incrementing integer to a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to print out a one page report that has an incrementing value printed
on it. For example, if i print out the report 10 times, i need the report to
say "Copy 1 of 10" "2 of 10" etc.

The report currently prompts for # of copies but i do not know how to get
this information onto the report.

The easiest thing for me to do would be to have the report ask the user how
many copies then create the same page 10 times. Then i could use the page #
1 of 10 function for the report.

Is there an easy way to do this ?
Thanks,
Frank
 
Create a table of numbers "tblNums" with a single numeric field "Num" and
values 1,2,3,...10
Add this table to your report's record source query without joining it to
any other table. Add the Num field to your query grid. Use the Num field as
your primary sorting level and use the value in the Num Group Footer.

You can set the number of pages by filter the report where Num <= some
value.
 
Thank you very much Duane !! That worked great.

Duane Hookom said:
Create a table of numbers "tblNums" with a single numeric field "Num" and
values 1,2,3,...10
Add this table to your report's record source query without joining it to
any other table. Add the Num field to your query grid. Use the Num field as
your primary sorting level and use the value in the Num Group Footer.

You can set the number of pages by filter the report where Num <= some
value.
Click to expand...
 
Back
Top