make a multi page report based on a value in qty field

[Michael]

I have a order that has many products, each product has a qty of pallets, I
need to make a report that prints an information page for each pallet of
each product.

Each page should also have 1 of 3, 2 of 3 ect. I have been trying many
things and nothing comes close, can someone give some idea of where to
start? Below is a sample of a order

Order ID 1

date product productID pallets
7/7/2005 product 1 01 8
7/7/2005 product 2 02 4
7/7/2005 product 3 03 2

thank you
Michael

 

[Allen Browne]

To print for each of the quantity, use a cartesian product to get the number
of records you need. Details in this example:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

It's messy handling total page count though. Information on how to handle
that:
Printing First and Last Page Numbers for Report Groups
at:
http://www.mvps.org/access/reports/rpt0013.htm

An alternative approach would be to use a loop to OpenReport several times.
This approach also has problems (memory loss) if the report contains
embedded objects.

 

[Michael]

Thank you Allen, that was just what I needed...
Michael