How do I detect #NUM! in a 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.
I would like to be able to detect this error and ignore this in my Access
query, am I able to?

 

[[MVP] S.Clark]

Use Nz() in your expression.

 

[Guest]

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.