wildcards

F

flow23

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