IsNull and IsNotNull

B

Bonnie

Using AXP. I use IIf IsNull in queries but sometimes need
IsNotNull. I get an 'Undefined Function...' error. I know
this is a stupid question but rather than having to use
<>"", is there a way to get IsNotNull?

Thanks in advance for any help or advice.
 
C

Cheryl Fischer

Try "not IsNull" ...

IIf(Not IsNull([MyField]),"something","something else")


hth,
 
Top