User critera and wild cards

[GregB]

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!

 

[Al Campagna]

Greg,
For textual critera...
Like "*" & [SomeField] & "*"
--
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."

 

[GregB]

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