Forum Discussion
negbc
Helper II
Helper IIMultiple 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=...
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
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
negbcParentheses, of course! Thanks!