Wednesday, March 7, 2012

Null Values

How can I sepcify a NULL value in a formula? I tried this but it told me to
use system.dbnull and that doesn't work either
=Iif( Fields!c_first_name.Value = NULL, Fields!c_last_name.Value,
Fields!c_first_name.Value)
THanks,Hi,
Replace 'Null' with 'Nothing' and it should work.
hth,
Pieter
"Eric" <Eric@.discussions.microsoft.com> wrote in message
news:70E8E267-D5C8-486D-8D89-931AACC876D3@.microsoft.com...
> How can I sepcify a NULL value in a formula? I tried this but it told me
> to
> use system.dbnull and that doesn't work either
> =Iif( Fields!c_first_name.Value = NULL, Fields!c_last_name.Value,
> Fields!c_first_name.Value)
>
> THanks,

No comments:

Post a Comment