Hello,
I am trying to write a nested IIf query which has two conditions and one of them being an AND:
Here is my unsucessful attempt at the query:
Assessment: IIf([CPT4]="1005F",1,IIf([CPT4]="2015F" And "2016F",1,0))
In plain english, I am trying to return a 1 value when the CPT4 field = 1005F
OR return a 1 value when the CPT4 field = 2015F AND 2016F
so, I have mutiple rows for each patient and one row must have 2015F and another row for the same patient must have 2016F in order to return a 1.
Hope this makes some sense.
Thanks a lot
w