I am repeating this question again, as I don't think I was specific enough on the previous version!
In Access 97, I have a query that has two fields: Item and Qty. The first field has an Item Number such as 1234567 and the second field contains the quantity of that number, eg 10.
I have set up a label report to print these two fields onto labels (mini address type so that I can label all my stock) and all works fine, but only prints one label of every item, regardless of the figure in the quantity field. The report screen in design view is 3cm by 2.5cm - a slightly customized version of the label wizard. The question, however, is how do I get Access to print 10 labels of 1234567 and not just one?
In other words, it should automatically look at the quantity field and print as many labels as specified and not 1!
Hopefully, it is something dead simple and I just haven't spotted it yet! Any help would be greatly appreciated
In Access 97, I have a query that has two fields: Item and Qty. The first field has an Item Number such as 1234567 and the second field contains the quantity of that number, eg 10.
I have set up a label report to print these two fields onto labels (mini address type so that I can label all my stock) and all works fine, but only prints one label of every item, regardless of the figure in the quantity field. The report screen in design view is 3cm by 2.5cm - a slightly customized version of the label wizard. The question, however, is how do I get Access to print 10 labels of 1234567 and not just one?
In other words, it should automatically look at the quantity field and print as many labels as specified and not 1!
Hopefully, it is something dead simple and I just haven't spotted it yet! Any help would be greatly appreciated