Displaying query records where field is null

[dderolph]

Hi everyone, my first post here.

I'm taking a class on Access and I'm working on an assignment where one of the requirements is to create a query which displays only those records where a field, named PermitNum, is null, or empty, in a table named tblCitation. 8 records should be displayed. I can't get this to work.

I'm thinking I need to use the IsNull function. I've tried different expressions which do not cause an error when the query is run but no records are displayed.

Do I need to use IIf in conjuntion with the IsNull function? Should this be part of the expression?: IsNull([tblCitation]![PermitNum])


I'm referring to the Criteria box for the PermitNum field in Design View for a Query, Access 2007.

 

[pbaldy]

Neither; in design view of a query, put this in the criteria line under that field:

Is Null

 

[dderolph]

Hmm, so, I was making it way too complicated. That worked. Thank you!

 

[The_Doc_Man]

You can also do this in a query:

In the field, IsNull( [Fieldname] )

In the criteria, =TRUE

 

[dderolph]

I tried that and I see how it works. Thanks for that info.