Trouble with 'Like' expressions as query criteria

G

Guest

Anyone have any trouble with 'Like' expressions as query criteria after
converting from '97 to '03 ???? Here is a smple Like expression that is not
working in '03 :
Like "|[forms]![frmtest]![txtTest]|"
 
K

Ken Snell [MVP]

What does "not working" mean? You get no results? You get the wrong results?
you get all the results?

What type of data are in the txtTest textbox?
 
V

Van T. Dinh

* You should always use Wildcards if you use Like.

* The syntax is wrong and I am not sure what the 2 vertical bars are for.

* Try:

Like "*" & [forms]![frmtest]![txtTest] & "*"
 

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

Expression builder trouble 1
Query Based on Main and SubForm ID Fields Not Working 2
How to keep Access from rearranging logical expressions iin the criteria cells ? 4
Use In() Expression as Query criteria with guts from Function 1
Problem Passing Parameter from Form 3
Getting query to look up the values of combo boxes then display da 6
Using expressions for Query criteria 2
Like is Null Query from Form 3

Top