Query - Filtering using multiple zip codes.

[kdtrimble]

I need to run a query that reports all sales from a list of 83 zip codes. I have not found out how to do this other than TEXT FILTERS - CONTAINS and then type each zip code in parenthesis and then OR.


Is there an easier way?

[pbaldy]

From a selection of them:

http://www.baldyweb.com/multiselect.htm

from all of them, presuming they're in a table, join that table in your query on zip code and it will be restricted to those.

[kdtrimble]

Oh boy... Thanks pbaldy but I have no clue as to what this sciprt is and how it's used.

[pbaldy]

Do you want the report on all 83 zip codes or allow the user to select one or more?

[orange]

kdtrimble,

If you know the 83 zips involved, you could put those in a separate table; then create a query to find records where the zips matched those in your separate table.
Here is a link to a tutorial that may be helpful.
Note: The sample deal with "exclude", you want the zips to "match/equal".

Good luck with your project.

[kdtrimble]

all 83 zip codes

[kdtrimble]

thank you very much

[kdtrimble]

I am getting a type mismatch.

[pbaldy]

Make sure the data types of the fields being joined on are the same in each table.

[kdtrimble]

yes, but my problem is I do not know how to check and change them lol. Can you help me please?

[pbaldy]

Not without the database. Just look at the tables in design view and check the data types of those fields.

[orange]

Your zip codes are right justified which is indicative of a number datatype. Since you do not do arithmetic with zip codes, they should be text.
Good luck.

[kdtrimble]

It works! Thank you all so much.