How to query for multiple criteria?

[William Smith]

Access 97 - need to extract from large database a dynaset of "contacts"
based on zip codes. If I have 1000+ names and need to extract 100+ zip
codes from them, what is easiest way to query this? I have tried to use the
"IN" operator....like so..
In(19708,19709,19711,21201.......21907), but apparently I am inputting more
than the 1024 characters allowed in the query wizard. I switched to SQL
view and inserted the wanted zip codes that way and it worked at first, but
then I did something wrong and since then am tsol...(lost backwards!). Does
any one have an idea on way to find some zip codes in a table of many?
Thanks, Willy

[Allen Browne]

Could you create a table containing a record for each zip code you want, and
INNER JOIN that to your contacts?

Alternativley, if you already have a table of zip codes, you could add a
yes/no field and check the box for the ones you want. Then create a query
joining the 2 tables, with True in the Criteria row under the yes/no field.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"William Smith" <wi***@oya.com> wrote in message
news:10*************@corp.supernews.com...

Access 97 - need to extract from large database a dynaset of "contacts"
based on zip codes. If I have 1000+ names and need to extract 100+ zip
codes from them, what is easiest way to query this? I have tried to use the "IN" operator....like so..
In(19708,19709,19711,21201.......21907), but apparently I am inputting more than the 1024 characters allowed in the query wizard. I switched to SQL
view and inserted the wanted zip codes that way and it worked at first, but then I did something wrong and since then am tsol...(lost backwards!). Does any one have an idea on way to find some zip codes in a table of many?
Thanks, Willy

[CDB]

Put the required zips into a (temp) table, and join the two tables in the
outpu query.

Clive
"William Smith" <wi***@oya.com> wrote in message
news:10*************@corp.supernews.com...

Access 97 - need to extract from large database a dynaset of "contacts"
based on zip codes. If I have 1000+ names and need to extract 100+ zip
codes from them, what is easiest way to query this? I have tried to use the "IN" operator....like so..
In(19708,19709,19711,21201.......21907), but apparently I am inputting more than the 1024 characters allowed in the query wizard. I switched to SQL
view and inserted the wanted zip codes that way and it worked at first, but then I did something wrong and since then am tsol...(lost backwards!). Does any one have an idea on way to find some zip codes in a table of many?
Thanks, Willy