label report

[Robgould]

Hello,

I have a database with a customers table. I want to print out a list of mailing addresses. I know basically how to do this, but I wnat to add an option to end user. I don't want to build the report on only one label. I woud like to allow the user to choose which label they want to use. Any ideas? Would it be easier to output to Word?

 

[llkhoutx]

I do this by adding dummy records for each blank label preceding the label(s) with data..

 

[AN60]

Do you want the user to be able to choose the addresses they wish to print on a label or labels? If you have a small number of addresses you could use a check box on your entry form then sort your report query based on the checkbox. I only have a small db with a low number of records so that's what I do. For large db's with heaps of records that might be a bit slow or tacky. Maybe you could come up with a parameter in your report query that will meet your needs.