T
tmwilkin
Something in this below query is not returning all the values I need, so I
need to examine it a bit further to see what it is doing. I don't know IIf
statements in SQL too well, so any translation of the below would be very
helpful.
IIf(IIf([CRMAST]![Points_Owned] And [CRMAST_1]![Points_Owned],[T4: Agg
Sales]![Total
Points]-[CRMAST]![Points_Owned]-[CRMAST_1]![Points_Owned],IIf([CRMAST]![Points_Owned],[T4:
Agg Sales]![Total
Points]-[CRMAST]![Points_Owned],IIf([CRMAST_1]![Points_Owned],[T4: Agg
Sales]![Total Points]-[CRMAST_1]![Points_Owned],[T4: Agg Sales]![Total
Points])))<0,0,1)
I really just can't figure out the beginning AND part of
"IIf([CRMAST]![Points_Owned] And [CRMAST_1]![Points_Owned]". To me this says
if valueX from table1 and valueX from table2... but doesn't give a condition,
such as = or <>.
Thanks for any help!
Todd
need to examine it a bit further to see what it is doing. I don't know IIf
statements in SQL too well, so any translation of the below would be very
helpful.
IIf(IIf([CRMAST]![Points_Owned] And [CRMAST_1]![Points_Owned],[T4: Agg
Sales]![Total
Points]-[CRMAST]![Points_Owned]-[CRMAST_1]![Points_Owned],IIf([CRMAST]![Points_Owned],[T4:
Agg Sales]![Total
Points]-[CRMAST]![Points_Owned],IIf([CRMAST_1]![Points_Owned],[T4: Agg
Sales]![Total Points]-[CRMAST_1]![Points_Owned],[T4: Agg Sales]![Total
Points])))<0,0,1)
I really just can't figure out the beginning AND part of
"IIf([CRMAST]![Points_Owned] And [CRMAST_1]![Points_Owned]". To me this says
if valueX from table1 and valueX from table2... but doesn't give a condition,
such as = or <>.
Thanks for any help!
Todd