Mailing labels

[Guest]

I have a table that stores data for two address types - physical and mailing.
I have a field called label_code which tells which of these addresses to use
when sending mail. I need to generate mailing labels and have created a
query to base the labels on. I need a way to distinguish which addresses
will go on the labels.

Is there a way to code the query by letting the user pick the label code
they want (M or P), and based on that, Access pulls the right addresses for
the labels?

Or should I create two queries (one with the mailing address info, the other
with the physical address info) and the user picks off of a menu which
address labels they want to print?

Thanks for any ideas!

 

[Jeff Boyce]

Lori

Look into Access HELP re: "parameter" queries. By adding something like the
following:

[Type "M" for Mailing Address Labels or "P" for Physical Address Labels]

in the criterion "cell" below the LabelType field in your query design,
Access will prompt with whatever you've typed between the square brackets
([]).

Regards

Jeff Boyce
Microsoft Office/Access MVP