ERROR on expression in my form
They are both field names
-----Original Message-----
Are you using Field Names(from table) or contral names
(from form). If they
are not the same, then I would try using the alternate
of what You are
using...
Katrina
wrote in message
...
there are values in the field
-----Original Message-----
If there are no values in the fields then you will get
an error. Try using
=NZ([Number Units],0)/nz([Total Units Inspected],0)
This will set the default values in the calculation to
zero if the fields
are Null
HTH
Kat
Nadia wrote in
message
...
I can't explain how my expression worked the first
time I
opened my form but now keeps displaying error.
It's a
simple expression
=[Number Units]/[Total Units Inspected]
Can anyone help me. I've tried re-creating the text
box
and re-entering the expression but still it won't
work.
My field names are correct. What is with this???
PLEASE HELP ASAP...thank you in advance!!!!
.
.
|