Multiple criteria in one field- query by form

O

opekemi

Hello all,

I have a form that feeds a query with information, in my query I
currently have this:

[Company] Like [Forms]![QBF_Form]![Sales] & "*" Or
[Forms]![QBF_Form]![Sales] Is Null

When I fill in a value in one of the fields, e.g. "data*" the query
brings up all information with the word "data" in it. If I don't fill
in any fields, the query returns all the values. So this is working
well so far.

However, when I fill in something like "data* or vent*" in one of the
form fields, I don't get any query results, so each field works with
just one criteria.

How do I change the query expression above so I can search for multiple
criteria in one field using "or"?

Thanks a lot for your help!
 

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

Top