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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional concatenation of fields 2
Help with AND/OR, IIF, ISNULL, ISNOTNULL, LIKE?? 17
Multiple IIf statements 2
Fields with Data only 7
Filter by Form query will not populate fields 2
Remove zero totals in query 4
2007 Macro conditions 2
What Framework Classes Do You Use the Most? 1

Back
Top