Printing various pages of report for selected records

[Guest]

I have a query with the following fields: LastName, FirstName, PhoneNumber,
and NumberOfTickets. I need to print tickets, which I created as a report,
based on the value in NumberOfTickets field.

The ticket report has LastName, FirstName, and PhoneNumber fields. How do I
loop printing the reports for all records based on their NumberOfTickets
value. Some records may have only 1 tickets while other records may have
more than 1 tickets.

Any tips will be appreciated.

RT

 

[Duane Hookom]

You can create a table "tblNums" with a single numeric field "Num" with
numbers 1 through your maximum NumberOfTickets. Add this table to your
report's record source and set the criteria under the Num field to:
<=[NumberOfTickets]
This will result in 3 duplicate records where the NumberOfTickets value is
3.

 

[Guest]

Thanks! I am going to try your advice and post the result when I am done.

RT

You can create a table "tblNums" with a single numeric field "Num" with
numbers 1 through your maximum NumberOfTickets. Add this table to your
report's record source and set the criteria under the Num field to:
<=[NumberOfTickets]
This will result in 3 duplicate records where the NumberOfTickets value is
3.

--
Duane Hookom
MS Access MVP

I have a query with the following fields: LastName, FirstName, PhoneNumber,
and NumberOfTickets. I need to print tickets, which I created as a
report,
based on the value in NumberOfTickets field.

The ticket report has LastName, FirstName, and PhoneNumber fields. How do
I
loop printing the reports for all records based on their NumberOfTickets
value. Some records may have only 1 tickets while other records may have
more than 1 tickets.

Any tips will be appreciated.

RT

 

[Guest]

Thanks, Duane! It works beautifully.

RT

You can create a table "tblNums" with a single numeric field "Num" with
numbers 1 through your maximum NumberOfTickets. Add this table to your
report's record source and set the criteria under the Num field to:
<=[NumberOfTickets]
This will result in 3 duplicate records where the NumberOfTickets value is
3.

--
Duane Hookom
MS Access MVP

I have a query with the following fields: LastName, FirstName, PhoneNumber,
and NumberOfTickets. I need to print tickets, which I created as a
report,
based on the value in NumberOfTickets field.

The ticket report has LastName, FirstName, and PhoneNumber fields. How do
I
loop printing the reports for all records based on their NumberOfTickets
value. Some records may have only 1 tickets while other records may have
more than 1 tickets.

Any tips will be appreciated.

RT