Hi!
I am beginner in MS Access and need assistance in printing multiple copies of different labels in a single report. I have a huge list of 2000 products and need to print out shipping labels of different products as per varying requirement in a single report. eg. if I need to print twenty nos. of labels of Product No. 5 (Prd 5) & six nos. of Product No. 44 (PRD 44) & thirty nos. of Product No. 200 (Prd 200) & so on depending on the requirement in single report and next time the quantity may vary as per the different requirement.
Is there a simple method wherein I can design a simple sheet / form/ query or simple VBA code (have no knowlegde of VBA!) and just put in the number of labels of required of a particular in a field box against the product name(s) and those particular products (names) are printed in a single report as per specified quantity?
Sample of the database is as follows:
ID ProductName
1 Prd 1
2 Prd 2
3 Prd 3
. .
. .
2000 Prd 2000
Any help in this regard will be highly appreciated.