Query only records that are missing entries

[flavioso]

Hello and thanks to anyone in advance. I have a database that is used a phone log where users log their phone calls. My issue is that sometimes a user fails to log specific information in a field.

Is there any way to create a query where it only returns records that are missing information in one of the fields? Is this possible?

I appreciate any suggestions on how to do this.

Bradley

 

[MarkK]

WHERE SomeField Is Null OR SomeField = ''

alternatively

WHERE Nz(SomeField, '') = ''

 

[flavioso]

That worked perfectly with Nz. Thank you so much.

WHERE SomeField Is Null OR SomeField = ''

alternatively

WHERE Nz(SomeField, '') = ''