Sequentially numbered stock cards

[James]

I have a sales order database (comprising 3 main tables: Order Header, Order
Lines and Stock) and I'm trying to create a report that will allow me to type
in an order number and then it will print 1 page per item per quantity on an
order, pulling the product details (sizes, colours etc.) from the Stock table.

For example if a customer has ordered 5 of "Product A" and 2 of "Product B"
I want the report to print 5 separate cards (pages) for "A" which should be
numbered 1 of 5, 2 of 5 etc. and 2 separate cards for "B" numbered 1 of 2, 2
of 2.

I did it in a DOS based version of Dataease years ago but would like to use
Access. I really don't know where to start with this in VBA.

 

[Duane Hookom]

If I understand correctly, you can create a table of numbers [tblNums] with
a single, numeric field [Num] and enter records with values 1 - max number
of quantity. Add this table to your report's record source and don't join it
to any other table. Add the [Num] field to the query grid and set the
criteria under it to:
<=[Quantity]
You can then bind a text box to:
=[Nu] & " of " & [Quantity]