IIF statement is not working

[jen-chi]

I have a calculated field produces the following sentence "7 episodes per 2
months, max duration per episodes is 1 day" the problem is I need to say if
this statement is null then use another column to populate data. This is
what I came up with:

Illness: IIf([Stips (stage 1)]![Illness Allotment]="",[Stips (stage
1)]![Stipulation],[Stips (stage 1)]![Illness Allotment])

When I attempt the second calculation I do not get any error messages and at
the same time my blank fields are not being populated with the non-blank
Stipulation field that I want to carry over.

Any suggestions?

 

[MGFoster]

I have a calculated field produces the following sentence "7 episodes per 2
months, max duration per episodes is 1 day" the problem is I need to say if
this statement is null then use another column to populate data. This is
what I came up with:

Illness: IIf([Stips (stage 1)]![Illness Allotment]="",[Stips (stage
1)]![Stipulation],[Stips (stage 1)]![Illness Allotment])

When I attempt the second calculation I do not get any error messages and at
the same time my blank fields are not being populated with the non-blank
Stipulation field that I want to carry over.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

There's a difference between NULL and an empty string "". If the column
(field) [Illness Allotment] is truly a NULL then use the IS NULL op:

Illness: IIf([Stips (stage 1)]![Illness Allotment] IS NULL,[Stips (stage

1)]![Stipulation],[Stips (stage 1)]![Illness Allotment])


HTH,
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSqc19IechKqOuFEgEQLHpgCfQ9FWC/xYfNqYJXEFNVmPVmoh7zkAoPdS
+rr011CTWtJjC+NnLZlWBNod
=bSx8
-----END PGP SIGNATURE-----

 

[jen-chi]

It worked and thanks!

Jeni

I have a calculated field produces the following sentence "7 episodes per 2
months, max duration per episodes is 1 day" the problem is I need to say if
this statement is null then use another column to populate data. This is
what I came up with:

Illness: IIf([Stips (stage 1)]![Illness Allotment]="",[Stips (stage
1)]![Stipulation],[Stips (stage 1)]![Illness Allotment])

When I attempt the second calculation I do not get any error messages and at
the same time my blank fields are not being populated with the non-blank
Stipulation field that I want to carry over.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

There's a difference between NULL and an empty string "". If the column
(field) [Illness Allotment] is truly a NULL then use the IS NULL op:

Illness: IIf([Stips (stage 1)]![Illness Allotment] IS NULL,[Stips (stage

1)]![Stipulation],[Stips (stage 1)]![Illness Allotment])


HTH,
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSqc19IechKqOuFEgEQLHpgCfQ9FWC/xYfNqYJXEFNVmPVmoh7zkAoPdS
+rr011CTWtJjC+NnLZlWBNod
=bSx8
-----END PGP SIGNATURE-----