ERROR on expression in my form

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

 

[Katrina]

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

 

[Guest]

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

.

 

[Katrina]

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

.

 

[Guest]

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


.

.

 

[Katrina]

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


.

.