How do I detect #NUM! in a Query?

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

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?
 
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.
 
Back
Top