Null value in function (1 Viewer)

hycho

Registered User.
Local time
Today, 10:21
Joined
Sep 7, 2011
Messages
59
Hi,

I am trying to using an iff statement to pick up null values, but I don't know what to type in the function. I tried using "is null", but got an invalid message.

Does anyone know what value I should type in to get null value in the function below?

IIf([popi_r2a] is null","",[popi_r2a])


Thanks.
 

DJkarl

Registered User.
Local time
Today, 09:21
Joined
Mar 16, 2007
Messages
1,028
Use the following.

NZ([popi_r2a],'')
 

Users who are viewing this thread

Top Bottom