How do I print (Qty) of labels of one record

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

Guest

I have a sales order form that when you enter a quantity (field name =
[Item_Qty]) it needs to print off [Item_Qty] of labels for that particular
order.
to complicate the problem even more, there can be several diffenet Items on
an Order, each with a different [Item_Qty]

Any suggestions will be greatly appreciated

Thanks Tim
 
Make a table (tblNums) with a single numeric field (Num) and records 1-[Max
of your quanity]. You can then use this table in a query with your sales
detail. The following is a similar query that does this with the Order
Details table in Northwind:

SELECT OrderID, ProductID, tblNums.Num, Quantity
FROM [Order Details], tblNums
WHERE OrderID=10248 AND Num Between 1 And [Quantity]
ORDER BY ProductID, Num;
 
Back
Top