print multiple lines of the same product

  • Thread starter Thread starter Nigel
  • Start date Start date
N

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
 
Nigel said:
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
Click to expand...


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
 
perfect thanks


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