#Error

  • Thread starter Thread starter Mike F
  • Start date Start date
M

Mike F

I want to match two tables, but some informations is not
in the second table and I have "#Error" as result. I can't
have a right summation 'cause this "#Error". Is it
possible instead off to have "#Error" as result, have "0".
Like that the summation can function.
 
Have you tried an IIF statement?

Im not sure if it'll work but you could try;
IIf([Field Name]="#Error",0,[Field Name])

Obviously, replace [Field Name] with your field name.

Steve.
 
Mike said:
I want to match two tables, but some informations is not
in the second table and I have "#Error" as result. I can't
have a right summation 'cause this "#Error". Is it
possible instead off to have "#Error" as result, have "0".
Like that the summation can function.
Click to expand...


I would be more concerned about why you're getting #Error in
a field. If you'd fix that, the other issue would probably
be easier to deal with. Most likely, you can avoid any
problem with Null by using the Nz function.

As a last resort, you can check for #Error by using
something like:

IIf(IsError(xxx), 0, xxx)
 
Back
Top