I've been asked to create a database that print labels. The main fields the database contains are Part Number, Part Type and Quantity. I have created a basic report that has the label template. My question is I'm struggling to find a way of printing duplicate labels, for example is I enter 5 in the quantity field then I want the report to print 5 labels and each label to appear in the format 1 of 5, 2 of 5, 3 of 5 etc. Is there a function or command that enables me to do this. I hope I've made this clear to you all!

Any help will be much appreciated....

I think if you look in the sample database section I recall that Ken Higgs had a label printing database there.

-dK

Thanks for your quick reply. I'm ok setting the database to print labels. It's just one of the fields that is displayed on the label needs to display the information as 1 of 5, 2 of 5 etc.

lol .. my bad - my fingers typed faster than my brain.

Now that I have reread - I really am not sure ... there is the paging code ..


= [Page] & " of " & [Pages]


but I am not sure how that works with labels meaning is each label it's own page? I would guess not because I've done labels using the columns bit. Hmmm. I will have to dig around and play for a bit unless someone else knows?

-dK

Just as a heads up ... I haven't gotten anywhere except to put an unbound text box on the label, set running sum over all, and for the control source use =1. So it will go 1, 2 , 3 ....

I am not sure about the total side of things.

-dK