print labels

W

waldorfedu

I need to print labels (Avery 5160) from Table (First Name, Last Name,
School, Street, City, State, Zip). However, Table includes some duplications
and also some records where pdf has been sent instead of physical copies so
no need to mail to either of these. What is the best way of excluding
duplications and where record has no address so I end up with labels for
records excluding same? Thanks
 
W

Wayne-I-M

Hi

To get just one lable per address
Run the labels from a totals query (count of the zip code/post code - if all
addess have these if not use another field).

To remove any records without 1s tline of address
Put "Not Is Null" is the criteria row of the first line of the address to
remove any records that don't have one

Good Luck
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top