Null dates

M

MIKE

Can anyone help ?
what would be the criteria for finding date fields when no dates have been
entered.
I need to find all records with no dates entered
 
J

Jeff Boyce

Mike

One approach might be to use

Is Null

as the criteria in the query design grid for the date field.

Good luck

Jeff Boyce
<Access MVP>
 
Top