Need to Pull Records Based on First 3 Digits Of Zip Code

S

shep

I need a query to pull records based on first 3 digits of Zip code. I need
to be able to include several Zip codes (first 3 digits) in criteria.

How can I do this?

Thanks
 
F

freakazeud

Hi,
do you have these zip codes stored already? Then just use this in your
criteria:

Left ([YourField], 3)

If not than create a zip code table and include the zipcode field in the
query. Then set the criteria similar.
HTH
Good luck
 
W

Wayne Morgan

Base the restriction on a calculated field.

Example:
FilterZip: Left([TableName].[ZipCodeField], 3)

then set the sorting to Ascending or Descending if desired. Set the criteria
to the first 3 characters in the zip code (i.e. "345"). You can uncheck the
Show box, if desired, to remove this field from the queries output. It will
still filter and sort (as appropriate) on it if you've made either of those
selections. If you make neither of those selections and uncheck the Show
box, Access will drop it from the query since it doesn't do anything.
 
S

shep

Thanks for your response

freakazeud said:
Hi,
do you have these zip codes stored already? Then just use this in your
criteria:

Left ([YourField], 3)

If not than create a zip code table and include the zipcode field in the
query. Then set the criteria similar.
HTH
Good luck
--
Oliver
Admin Specialist & Computer Science Major @ UMD - Go Terps - :)


shep said:
I need a query to pull records based on first 3 digits of Zip code. I need
to be able to include several Zip codes (first 3 digits) in criteria.

How can I do this?

Thanks
Click to expand...
Click to expand...
 
S

shep

Thank you, that is what I needed.

Wayne Morgan said:
Base the restriction on a calculated field.

Example:
FilterZip: Left([TableName].[ZipCodeField], 3)

then set the sorting to Ascending or Descending if desired. Set the criteria
to the first 3 characters in the zip code (i.e. "345"). You can uncheck the
Show box, if desired, to remove this field from the queries output. It will
still filter and sort (as appropriate) on it if you've made either of those
selections. If you make neither of those selections and uncheck the Show
box, Access will drop it from the query since it doesn't do anything.

--
Wayne Morgan
MS Access MVP


shep said:
I need a query to pull records based on first 3 digits of Zip code. I need
to be able to include several Zip codes (first 3 digits) in criteria.

How can I do this?

Thanks
Click to expand...
Click to expand...
 
F

Frederick Wilson

shep said:
I need a query to pull records based on first 3 digits of Zip code. I need
to be able to include several Zip codes (first 3 digits) in criteria.

How can I do this?

Thanks
Click to expand...

Not sure if this recommendation is what you are looking for but in the
criteria of zip code field input Like "123*"

That will give you all the zip codes that start with 123.

Changing it to read Like "624" will give you the all the zips with 624
in the first three character


--
Frederick Wilson

_____________________________________
for multimedia design services visit
http://www.legalanimatics.com
 
Top