IF THEN IF THEN ELSE ...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two fields [A] and , and I am needing to eval both of them.
If [A] is Null
then
If Is Null
THEN "0" //my train of thought both must be null to get to here
ELSE //gives the value of
ELSE [A] //gives value of [A], which should not be null since this is executing

if 'A' is null then goto 'B'; if 'B' is null then show '0'



A B
1 should show 1
2 should show 2
3 4 should show 3
shoudl show 0, both are null
 
Colby said:
I have two fields [A] and , and I am needing to eval both of them.
If [A] is Null
then
If Is Null
THEN "0" //my train of thought both must be null to get to here
ELSE //gives the value of
ELSE [A] //gives value of [A], which should not be null since this is executing

if 'A' is null then goto 'B'; if 'B' is null then show '0'



A B
1 should show 1
2 should show 2
3 4 should show 3
shoudl show 0, both are null
Click to expand...


=Nz([A], Nz(, 0))
 
Back
Top