#Error

  • Thread starter Thread starter 123
  • Start date Start date
1

123

Thank you...
Why This error ( #Error) appear when no data in data sheet form... and i'm
using Nz funtion but also display this error for example
=Nz(([Field1]+[Field2]),0)
 
In a calculation each field requires a numeric value to
work otherwise #Err will result.

Try = NZ(field1),0) + NZ(field2,0)

Rgds.
 
Back
Top