Querie to retrieve records with empy field

[Mr. G]

I would like to make a querie that should show only records that have a
certain field empty for example it should only show records that the "Date"
field is empty

 

[Roger Carlson]

Use:
IS NULL
as the criteria for the Date field.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Mr. G]

Thanks

Use:
IS NULL
as the criteria for the Date field.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L