I'm not that great in access and I was told by a friend of mine to come here for some help. So let me explain my issue.
I am working on a production database. I am trying to print labels of a product. If a customer orders 5, then I need to create 5 labels.
So I have a table "Orders" that holds each order. In the table there is a column for quantity "qty". So I do my report from a query which gets me the pertinant information to go on the label. Now if I have an order with a quantity of 5, how do I automatically get 5 labels to print instead of having to print the order 5 times? If this doesn't make sense, please let me know and I will try to explain in more detail.
I tried searching for the answer and I don't think I am doing the search properly.