Multiple Operators in Conditional Query

[negbc]

I have the code below that is returning the incorrect result. I believe it is the multiple 'or' conditions afterwards. Is there a solution to fix this so the result would be if the Line=ele AND ship=VA AND Category is any of the following then the result is cust whse. Or at least a better understanding of how this would be enterpreted? 

if [Line]="ELE" and [Ship]="VA" and [Category]=101 or [Category]=102 or [Category]=103 or [Category]=104 or [Category]=105 or [Category]=106 or [Category]=107 or [Category]=108 or [Category]=109 or [Category]=110
then [Cust]

Thanks!

[Anonymous · Accepted solution]

if ([Line]="ELE" and [Ship]="VA") and ([Category]=101 or [Category]=102 or [Category]=103 or [Category]=104 or [Category]=105 or [Category]=106 or [Category]=107 or [Category]=108 or [Category]=109 or [Category]=110)
then [Cust] else null

--Nate

[negbc]

Parentheses, of course! Thanks!