IsNull and IsNotNull

  • Thread starter Thread starter Bonnie
  • Start date Start date
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.
 
Try "not IsNull" ...

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


hth,
 
Back
Top