Using the like operator with input data

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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...
 
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

Use of Wildcard in String Expression 4
Like Criteria Question using a control from a Form 1
Problem with the Like Operator 2
Access Query Using Like & Wildcard Operators 6
Query wildcard symbols 4
Using "like" from an external link 1
Like Operator 2
Alike operator replacing Like; I don't know why or how to fix 1

Back
Top