Printing address labels

[MarionD]

Hi all,

I have created a report to print address labels using the wizard. It works fine for one client after another - but I want to print 1 page of labels for the same client. If I do openreport.... etc. where Id = me.ID (Client is the selected record on the form) I get just 1 label, not one page of labels? Is there anyway of doing this?

Thanks a million.. any help much appreciated.

 

[Ranman256]

Make a query, this will pull the 1 record using the index.
In another table put entries totaling the # of labels. If the page has 50 labels,put in 50 records....1 thru 50.

In the query add this table,but do not join them. It will multiply the records. And you will have 50 of the same person.

 

[MarionD]

Thanks so much from Germany to USA! - Works fine
Have a great day!
Marion