ERROR on expression in my form

  • Thread starter Thread starter Nadia
  • Start date Start date
N

Nadia

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!!!!
 
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
 
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
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!!!!
Click to expand...


.
Click to expand...
 
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
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
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!!!!
Click to expand...


.
Click to expand...
Click to expand...
 
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
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
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!!!!


.
Click to expand...
Click to expand...


.
Click to expand...
 
Try using control names.

Katrina
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
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
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!!!!


.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top