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