Cannot Print Correct Label Qty When Qty is 2 or More?

[gbs01]

I have an Access 2002 Inventory Database and want to print out Barcode Price Labels for each product on a recently received order.

1)I have a query called qryReceivedQtys to get the data
2)I created my Label Report based on my qryReceivedQtys
3)Heres my problem: Labels only print one for each product number instead of getting the number of labels for the total quantity of products.

This is a sample of my query data:
___________________________________________________________
ISBN Title Price Qty
___________________________________________________________
9932929233 Harry Potter 24.95 5
0909009932 Holy Bible 15.95 1

When I run the price label report I get two labels: one of each ISBN. Instead of 5 for Harry Potter and 1 for the Holy Bible. Can anyone help???

-Thanks

Jerry Alexander
jerry@gospeland.com

 

[PaulBricker]

Jerry, look at this faq by CosmoKramer. It does exactly what you need. Good luck.

faq703-3276


Paul

 

[gbs01]

Thank-You! So Much to PaulBricker & especially CosmoKramer!
That has to be one of the simplest tricks in the Book, and I have no Idea why it works!

Thanks again!
Jerry Alexander