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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query to filter dates as entered in and if not to show N 4
counting Null fields 3
Annual Census 2
Update date field to Is Null in an update query 3
#error - Blank 3
Access Dcount function in access 0
Return only records with empty field 1
date criteria or all 3

Top