Report Numbering

[jonp]

Hi all!

I have a report that users will print onto a pre-printed perforated form. When torn, users will have 4 equal size sheets of paper with the same information printed on each except for a special sequence number.

Users will have a form where they will enter a beginning number and the number of pages that they are printing. Ultimately, I need the report to take the beginning sequence number and add 1 to it for each section of the report for as many pages they specify on the form in Access.

Example: The user wants to print 5 pages with a beginning sequence number of 101. Once printed and torn apart there should be 20 equally sized pieces of paper each with a sequence number.

Right now the report prints brilliantly but I do not have the sequence feature installed.

Can anyone help?

Thanks in advance,
JON

 

[jonp]

Is there a way to repeat a record on a report based on an entered value?

JON

 

[hacker277]

i dont know if this will work or not but have the report write to the table to were the report will get the number, add one then put the numbber on the report and then put the number back to the table, and repeat for every detail section.

 

[joeyreyma]

you can try this one:

1. put two textbox in the section where you want to print the sequence number.
2. on the first textbox, set the controlsource to =1, then set the running sum to OVER GROUP, then set the visible to FALSE
3. on the second textbox, set the controlsource to =([Forms]![PrintReportForm]![BeginNumber]+[Reports]![MyReport]![Textbox1])-1. this will serve as your sequence number display.

where
* [Forms]![PrintReportForm]![BeginNumber] is your entry form begin number
* [Reports]![MyReport]![Textbox1] is the first textbox in the report
* -1 to reset your starting point by one