Query problem! help! TIA

[slam7053]

Hi, I've been trying to get this to work for a while, but to no avail: Basically I want access to return every company in our database where the description has the words like "restaurant" "dining" "cafe" "bistro" etc. in it. However, I do NOT want access to return any companies where the description has the words "manufacture" "equipment" "furniture" etc.



This is my query for the 'description':

Like *restaurant* OR *dining* or like “*quick*”&”*service*” or like “*fast*”&”*food*” or like *cafe* or like *bistro* or like *food truck* or like *cantina* and not like *manufacture* and not like *linen service* and not like *equipment* and not like *furniture* and not like *suppl*


Shouldn't this do what I want it to do? I've been trying to get this to work for like two hours this morning -_-'

Any help would be greatly appreciated!

[slam7053]

NEVER MIND I JUST FIXED IT!

Needed to put parentheses around the beginning part:

(Like *restaurant* OR *dining* or like “*quick*”&”*service*” or like “*fast*”&”*food*” or like *cafe* or like *bistro* or like *food truck* or like *cantina* )and not like *manufacture* and not like *linen service* and not like *equipment* and not like *furniture* and not like *suppl*

[orange]

I don't think your syntax is correct. These are strings and will require quotes to surround the strings.

Please post the full query.