Using IIF in Criteria to Filter a Null
Posted on 2011-10-17
I am using the query grid to add in the criteria. The IIF statement I am using is:
The field is a text field and returns a data type mis-match, when I am trying to filter by Is Null. I can open up the table in its own grid and use IS NULL to filter the fields I need.
How can I query a null value using an IIF statement - since "" doesn't work.