Barcodes - Looping output

[Barry]

I have a query which reports as follows:

Barcode, Description, Quantity.

How do I loop through to get 2 rows output if the quantity is 2

Thanks for any help.

[Rick Wannall]

You'll either need to create a temp table to hold a list of the records
you're printing, and store a row for each label you want to print, or use
code to drive the printing, but that only works if your format supports
printing a single label at a time, such as when the label takes up a full
page.

Either of these sound useful? We'll pursue whichever one suits your
situation.

[Rick Wannall]

"Developer's Handbook", as in THE Developer's Handbook (Getz et al)?

[pietlinden]

Barry wrote:

I have a query which reports as follows:

Barcode, Description, Quantity.

How do I loop through to get 2 rows output if the quantity is 2

Thanks for any help.

If you're using a report, you can control this completely without
creating any new records. There's an example in the Developer's
Handbook.

[w_a_n_n_a_l_l_ -]

For those, like me, who had not seen the solution in Access Developer's
Handbook, the section is "Printing Multiple Labels" in Volume 1, Chapter 9
in the Access 2000 version.

Slick