W
Whirled.Peas
I asked this question here many, many years ago and have since forgotten
the answer.
I have a table with address data in it, spread over several fields. One
of the fields is called "Zip" and is a text field of 5 characters in
length.
I am trying to write a query that will prompt the user to enter the first
FOUR digits of the zip code and have it return all matches for those four
characters.
For example, 1234 would return 12345, 12346, and 12347 and so on.
My recollection is that the query was something like:
SELECT * FROM addresses WHERE Zip LIKE "[Enter first four digits]%" but
that does not seem to work in Access 2007. I am probably misremembering.
Does anyone know the proper query syntax?
Thank you for your help.
the answer.
I have a table with address data in it, spread over several fields. One
of the fields is called "Zip" and is a text field of 5 characters in
length.
I am trying to write a query that will prompt the user to enter the first
FOUR digits of the zip code and have it return all matches for those four
characters.
For example, 1234 would return 12345, 12346, and 12347 and so on.
My recollection is that the query was something like:
SELECT * FROM addresses WHERE Zip LIKE "[Enter first four digits]%" but
that does not seem to work in Access 2007. I am probably misremembering.
Does anyone know the proper query syntax?
Thank you for your help.