Querying a Date field

  • Thread starter Thread starter Frank Winston
  • Start date Start date
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?
 
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?
 
Back
Top