Querying a Date field

F

Frank Winston

Trying to find records in a table where a date has not been
entered into a Date field. "Is Null" does not find the
records. What search criteria do I use to locate these
records?
 
J

John Spencer (MVP)

Is Null should work to find any records where the Date field is null and the
field is a DateTime field. Can you post the SQL that is not working?
 
Top