Delete Query for Non-date Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to build a query that will delete all records that do not have a date
in one field. I imported a text file and designated one field as a date
format. Some rows are headers, do not have dates in them, and I want to
delete them.
What criteria would I use?
"Not ISDATE" doesn't work.
TIA.
 
The criteria should be:
Is Null

Do not enter this with quotes around it; that would make it look for fields
contiaing the string "Is Null".

Rob
 
Thanks Rob.
I did use that criteria but had thought that there might be an entry that
wasn't a date and wasn't null. Seeing your answer, I started thinking that,
with my import specs set up as a date field requirement, these "non-date"
fields would end up as null even if they had something else in them.
 
Back
Top