Query Question

[George Sydney]

I have created a report by using a query to link to a MYOB database using
ODBC drivers.
The query uses 3 tables to get various information and i display this
information on a label. It is easy for me to do this because I display each
query line on each label on the report.
The problem I am having is that I need to produce a label per item I sell.
Each line of the query displays the information including the quantity BUT I
dont know how to take the quantity and produce multiple labels for that
particular query line.
EG Query line as follows
inv number, date, product description, customer, quantity
I can easily produce 1 label per line BUT my problem is I need 1 label per
qty per line.

Can anyone help me?

 

[Tom Wickerath]

Hi Frustrated,

Take one great article, and call me in the morning!

Print a Quantity of a Label
http://allenbrowne.com/ser-39.html


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________