Using the like operator with input data

G

Guest

I am getting an invalid syntax error when I apply the * wildcard character to
the follow criteria in a query.

Like [Forms]![Search Specific Model]![modelNumberTextBox]

Can someone help me with what I am doing wrong?
 
O

omocaig via AccessMonster.com

you need to concatenate the wildcard

starts with
Like [Forms]![Search Specific Model]![modelNumberTextBox] & "*"

or

ends with
Like "*" & [Forms]![Search Specific Model]![modelNumberTextBox]

or

contains
Like "*" & [Forms]![Search Specific Model]![modelNumberTextBox] & "*"

hth,
Giacomo

daniel said:
I am getting an invalid syntax error when I apply the * wildcard character to
the follow criteria in a query.

Like [Forms]![Search Specific Model]![modelNumberTextBox]

Can someone help me with what I am doing wrong?
Click to expand...
 
G

Guest

I can't see how you are attempting to apply the *. I'm not sure how you can
expect anyone to respond when we can't see what you are doing or your SQL
statement.
 

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

Problem with the Like Operator 2
Like Operator 2
Alike operator replacing Like; I don't know why or how to fix 1
Query using Like Operator 2
combine prompt with Like operator? 2
Difficulty with LIKE operator 4
Query wildcard symbols 4
Query criteria - the Like operator 5

Top