Setting up for Zip Code Search Queries

  • Thread starter Thread starter Airwolf
  • Start date Start date
A

Airwolf

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.
 
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.
 
Back
Top