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

Creating a Search using a combo box and then creating a report. 4
Split form 0
How to use/create code in MS Word to calculate age? 0
Add additional information to excel form after original data entry 0
Removing {PAGE/*MERGEFORMAT} from my microsoft document 5
Migrated outlook to G Suite server showing wrong dates 0
Repeated phrases wildcard? 1
Parameter Query to filter dates as entered in and if not to show N 4

Top