Like and access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arturo Guzman - 31 Jul 2006 19:37 GMT

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.

Reply to this Message

Jeff L - 31 Jul 2006 19:55 GMT

Select * from PostalCodes where PostalCode Like "17*"

If you want the user to enter a value:
Select * from PostalCodes where PostalCode Like [Enter a Postal Code] &
"*"

Hope that helps!

> Hello,
>
[quoted text clipped - 6 lines]
>
> Thanks for your replies.

Reply to this Message