Forum Discussion
Multiple Operators in Conditional Query
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!
- Anonymous1 year ago
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
2 Replies
- AnonymousNot applicable
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
- negbcHelper II
Parentheses, of course! Thanks!