Printing incremental numbers on tickets

[Guest]

Using Access 2002, I print tickets for a query. There are three tickets in a
sheet. A record may have one or more ticket sheets printed. I would like to
print number on each of the tickets on the sheet. The beginning number for a
record's tickets is stored as a field in the record.

How do I increment and print the number for the second, third, fourth, five,
and six tickets for the record?

TIA,

RT

 

[MA]

Using Access 2002, I print tickets for a query. There are three
tickets in a sheet. A record may have one or more ticket sheets
printed. I would like to print number on each of the tickets on the
sheet. The beginning number for a record's tickets is stored as a
field in the record.

How do I increment and print the number for the second, third,
fourth, five, and six tickets for the record?

put = 1 in a textbox e set the running sum on group (is a proprierty f the
control)

TIA,

RT

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it

 

[Guest]

Thanks for the tip! I forget to mentioned that the number is started with an
assigned number. Here is an example:

The starting number is 9595. The first ticket will have 9595, the second
ticket will have 9596, the third ticket willhave 9597, and so on.

Is it possible to be done?

TIA,

RT

 

[Duane Hookom]

Add another text box to your report and set its control source to:

=[Enter Start Number] - 1 + [NameOfYourRunningSumTextBox]

Make the running sum text box invisible.

 

[Guest]

Duane,

Thanks a bunch! Appreciate your help.

RT

Add another text box to your report and set its control source to:

=[Enter Start Number] - 1 + [NameOfYourRunningSumTextBox]

Make the running sum text box invisible.

--
Duane Hookom
MS Access MVP
--

Thanks for the tip! I forget to mentioned that the number is started with
an
assigned number. Here is an example:

The starting number is 9595. The first ticket will have 9595, the second
ticket will have 9596, the third ticket willhave 9597, and so on.

Is it possible to be done?

TIA,

RT