J
jbair via AccessMonster.com
I have a report based on the following query Where I can input an order
number and select the amount of labels I want to print, It works very well,
SELECT [Enter Sales Order] AS [Sales Order], tblCount.CountID
FROM LableTable, tblCount
WHERE (((tblCount.CountID)<=[how many labels do you want?]))
what I want to do is to automatically print those labels and run the query
again for a different order. I work in a production enviroment and need it
to be very quick for the operator so I am trying to avoid hitting the print
button and then opening the query again.. Any ideas? on how to accomplish
that would be greatly appreciated.
Jbair
number and select the amount of labels I want to print, It works very well,
SELECT [Enter Sales Order] AS [Sales Order], tblCount.CountID
FROM LableTable, tblCount
WHERE (((tblCount.CountID)<=[how many labels do you want?]))
what I want to do is to automatically print those labels and run the query
again for a different order. I work in a production enviroment and need it
to be very quick for the operator so I am trying to avoid hitting the print
button and then opening the query again.. Any ideas? on how to accomplish
that would be greatly appreciated.
Jbair