Printing various pages of report for selected records

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

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
 
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.
 
Thanks! I am going to try your advice and post the result when I am done.

RT

Duane Hookom said:
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


RT said:
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
Click to expand...
Click to expand...
 
Thanks, Duane! It works beautifully.

RT

Duane Hookom said:
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


RT said:
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
Click to expand...
Click to expand...
 
Back
Top