Detecting #NUM! in a MS query

[Guest]

I'm linking to an Excel spreadsheet which has values that don't match the
field format e.g. a date field type with value "new".
When I link this spreadsheet it has a NULL value, but I see #NUM! in the
field.
Nz() will detect the NULL value, but the spreadsheet field has a value. I
only want to see the records where the field in the spreadsheet is NULL,
hence I wish to know how to ignore fields with #NUM! in them.

 

[[MVP] S.Clark]

IsDate("new") = False

Try to use in your query.

 

[Guest]

This doesn't solve the problem. The blank field will also produce a FALSE
result and these are the ones I wishing to retain.