On Mon, 31 Jul 2006 20:36:57 +0200, Arturo Guzman wrote:
Hello,
I have a postal code field, when I run the query to ask the user which
postal code want to view.
I need to use like now, so if If the user wants all the postal codes
which begins in 17, Selec * from PostalCodes where "[PostalCode]*"
doesn´t work, what is the way to do it in access.
Thanks for your replies.
I'm sure you wish the user to be able to change the postal code
whenever he wants without modifying the query.
Select YourTable.* from YourTable where [PostalCodeField] Like [Enter
Start of code] & "*"
The user will be prompted of for the beginning of the code.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail