wildcards

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...
 
D

Douglas J. Steele

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

IS null 2
Parameter Value error in a Subform 0
Main Form and two Subforms 2
Access Dcount (multiple criteria) 3
Search criteria for querys 3
Date search query 0
Cascade queries 7
Query based on Check Box 1

Top