G
Guest
I need to convert the following excel IF statement to an Access IFF statement
IF(Q2="Y",IF( J2="N",1,0),0) and it returns results of 0 or 1.
where Q2 = where Q2 is the column named fcsdel and J2 is the column named
fcsadt
The statement I have currently does not produce the correct results as it
only returns 1, it is below.
Expr3: IIf([fcsdel]="Y",1,(IIf([fcsadt]="N",1,0)))
Any ideas?
IF(Q2="Y",IF( J2="N",1,0),0) and it returns results of 0 or 1.
where Q2 = where Q2 is the column named fcsdel and J2 is the column named
fcsadt
The statement I have currently does not produce the correct results as it
only returns 1, it is below.
Expr3: IIf([fcsdel]="Y",1,(IIf([fcsadt]="N",1,0)))
Any ideas?