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
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