wildcards

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I changed the following criteria in a query from

Like [Forms]![main]![Text45] & "*"

to

Like "*" & [Forms]![main]![Text45] & "*"

in order to search in the middle , end or part of the field.

but somehow the new criteria doesnt work.

any help appreciated...
 
It should (unless you're using ADO, in which case the wildcard character is
%, not *)

"doesn't work" isn't much to go on....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - Easy Question 7
IS null 2
Parameter Value error in a Subform 0
Access Dcount (multiple criteria) 3
Date search query 0
Search criteria for querys 3
Filter subform from combo unbound text box 3
Query based on Check Box 1

Back
Top