Setting up for Zip Code Search Queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Airwolf - 27 Feb 2007 00:14 GMT

I have an interesting situation I'm sure there is a simple solution to, but I
am unsure of how to make it work. In the entry form we want to ask for
multiple zip codes (I.e. "zip codes servicing") we want to be able to search
the database to make a report for "programs servicing zip code A."

#1- Is there a way to query a search through multiple zip codes within one
column from a text input or is it better to have a column for each of the 20+
zip codes.

#2- how would we set up the query to pull this off?

-Thanks in advance.

Reply to this Message

Allen Browne - 27 Feb 2007 00:40 GMT

Use a single column for the zip code.

Use an unbound multi-select list box as the interface where the user can
select the zip codes they want. For the code to open a report filtered by a
list box, see:
Use a multi-select list box to filter a report
at:
http://allenbrowne.com/ser-50.html
The code to filter a form would be identical.
You will need a form (in datasheeet view if you wish) rather than merely a
query to get this to work.

Signature

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.

>I have an interesting situation I'm sure there is a simple solution to, but
>I
[quoted text clipped - 11 lines]
>
> -Thanks in advance.

Reply to this Message

Airwolf - 27 Feb 2007 18:57 GMT

Thank you, I think this is what we were looking for!

>Use a single column for the zip code.
>
>Use an unbound multi-select list box as the interface where the user can
>select the zip codes they want. For the code to open a report filtered by a
>list box, see:

Reply to this Message