How do I specify the number of times a record is printed based on.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have 2 fields in a table: Item & Qty. I'm doing a Label Report based on
this table. How do I tell the report to print the number of Items based on
its Qty. For EX, if Qty is 5, I want to print that Item 5 times. I thought
about doing a VBA code to modify the table, but is there a simpler way?
Thanks
-ngan
 
Ngan said:
I have 2 fields in a table: Item & Qty. I'm doing a Label Report based on
this table. How do I tell the report to print the number of Items based on
its Qty. For EX, if Qty is 5, I want to print that Item 5 times. I thought
about doing a VBA code to modify the table, but is there a simpler way?
Click to expand...


Create a table named Numbers with one field named NumCopies.
Populate the table with consecutive numbers 1,2,3,... to
more than the maximum quantity you'll ever have.

Now you can create a query to use as the label report's
record source:

SELECT Sales.Item , Sales.Qty,
Numbers.NumCopies As ItemNumber
FROM Sales INNER JOIN Numbers
ON Numbers.NumCopies <= Sales.Qty
 
Back
Top