If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ERROR on expression in my form
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!!!! |
#2
|
|||
|
|||
ERROR on expression in my form
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!!!! |
#3
|
|||
|
|||
ERROR on expression in my form
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!!!! . |
#4
|
|||
|
|||
ERROR on expression in my form
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!!!! . |
#5
|
|||
|
|||
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!!!! . . |
#6
|
|||
|
|||
ERROR on expression in my form
Try using control names.
Katrina wrote in message ... 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!!!! . . |
Thread Tools | |
Display Modes | |
|
|