Null dates

  • Thread starter Thread starter MIKE
  • Start date Start date
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
 
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>
 
You must log in or register to reply here.

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
#error - Blank 3
Update date field to Is Null in an update query 3
Criteria for select query. 2
Access Dcount function in access 0
Return only records with empty field 1

Back
Top