print multiple lines of the same product

[Nigel]

what I need to do is repeat a line on a report multiple times depending on
the qty ordered.

So if we order 10 widgets for the work order I need it to print the same
line 10 times

field name is qty

thanks

 

[Marshall Barton]

what I need to do is repeat a line on a report multiple times depending on
the qty ordered.

So if we order 10 widgets for the work order I need it to print the same
line 10 times

field name is qty

Create a new table (named Numbers) with one field (named
Copies) and populate the table with records containing 1, 2,
3, ... up to more that the greatest quantity you will ever
have.

Then create a query for the report:

SELECT Orders.*, Numbers.Copies
FROM Orders, Numbers
WHERE Numbers.Copies <= Orders.Qty

 

[Nigel]

perfect thanks

Create a new table (named Numbers) with one field (named
Copies) and populate the table with records containing 1, 2,
3, ... up to more that the greatest quantity you will ever
have.

Then create a query for the report:

SELECT Orders.*, Numbers.Copies
FROM Orders, Numbers
WHERE Numbers.Copies <= Orders.Qty