I have a field in a table with a some values = '#ERROR' its an imported table so the #ERROR is expected and nothing I can do about it. I am trying to do a query that groups and counts the number of #ERRORS but get a data mismatch error therefore I am trying to substitute #ERROR for a blank I have used criteria : IIf([FieldName]="#Error"," ",[FieldName]) and also IIf(IsError([FieldName])," ",[FieldName]) But both still show the #ERROR. How can I get rid of the #ERROR text in the field?
Thanks