Creating a Select Query from another table

I

Ian

I'd like to use data from one table (the forward
sortation area(FSA) of postal codes) to create a select
query in another table (the actual postal codes of
potential clients). Right now I have one table with the
client info which includes postal codes:
e.g. N2T 2R8, N2R 2G5, N1R 3R5, etc...
and I create my select query using Like "N2T*" OR "N1R*"
OR etc...

I'd like to have all the FSA's listed in another table
and simply select the ones with a YES/NO box
Field 1: FSA
Field 2: YES/NO box for a given mailing
use a select query to choose the desired FSA's then
import these into the select query for the mailing list.

Can anyone help with this?

Ian
 

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