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
 
Top