User critera and wild cards

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GregB - 10 Apr 2008 12:58 GMT

When doing a criter input field for the user withe brackets []

How can I include Wildacards (*) around there searched input... I have tried
different formats but can not find a way..?

Thanks for your help!

Reply to this Message

Al Campagna - 10 Apr 2008 13:19 GMT

Greg,
For textual critera...
Like "*" & [SomeField] & "*"

Signature

hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

> When doing a criter input field for the user withe brackets []
>
[quoted text clipped - 3 lines]
>
> Thanks for your help!

Reply to this Message

GregB - 10 Apr 2008 13:24 GMT

Nevermind I was using the AND and not the & sighn
Sorry
Thanks anyways

> When doing a criter input field for the user withe brackets []
>
> How can I include Wildacards (*) around there searched input... I have tried
> different formats but can not find a way..?
>
> Thanks for your help!

Reply to this Message