I have an access database with a linked table, a query, and a report. The query is designed to pull out one unique record from the linked table based on the information entered by the user. The single record has a field we'll call "number of pieces". The report has the query data arranged in a readable format to print labels to affix to packages.
I need to print multiple copies of the label based on the number of pieces on the order. If the order has 4 pieces, then I need four labels. I have a field on the label described as "Piece ____ of ____". The ideal solution would have four labels print out with each lable showing Piece 1 of 4, Piece 2 of 4, Piece 3 of 4, Piece 4 of 4.
I'm not an access expert by any stretch of the imagination, but can figure out/learn new tricks as they are explained.
Thanks in advance for any help.