#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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
DSum update query with multiple fields 0
Converting Seconds to Hours, Minutes, Seconds 3
Error message - unique index created on two different fields 3
Coding bug 3
updated field 3
There is an invalid use of the .dot or ! or invalid parenthses 10
IIF / OR condition (can OR be used)? 2

Back
Top