Creating Mailing Labels for selected States?

S

scoot

Using Access 2000 on XP Pro: I have a query that contains names/addresses
from every state. At times I need to create a set of mailing labels for just
a few selected states. In the past I've used "filter by form" then "save as
new query". But that's one state at a time and is very time consuming. Is
there a way to group them all together.

Thank you!
 
P

PC Datasheet

Use the following expression in the criteria for State in your query:

In("Pa","Tx","Vt")
 

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

Similar Threads

labels for filtered forms 3
creating mailing labels 2
residential vs. mailing addresses 2
Creating mailing labels in Word from Excel merged data 4
help regarding creation of mailing labels. 1
Creating Address labels 1
mailing labels 1
Creating Mailing Labels 1

Top