multiple criteria in query by form (1 Viewer)

[odun]

Hello all,

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

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

When I fill in a value in the field e.g. "data*"the query brings up all information with the word "data" in it.

However, when I fill in something like "data* or vent*" I don't get any query results.

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!

 

[Smart]

However, when I fill in something like "data* or vent*" I don't get any query results.

like "data*" or like "vent*"

Should do the trick

 

[odun]

Hi Smart,
No this doesn't do the trick.

I am filling in the field in the form with my search criteria. This then runs the query.

I can not fill in "like data* or like vent *"

In the form field, I want to fill in: data* or vent*

Any ideas on how to do this are very welcome, thanks again!