A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

ERROR on expression in my form



 
 
Thread Tools Display Modes
  #1  
Old June 4th, 2004, 05:42 PM
Nadia
external usenet poster
 
Posts: n/a
Default 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  
Old June 4th, 2004, 05:49 PM
Katrina
external usenet poster
 
Posts: n/a
Default 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  
Old June 4th, 2004, 06:08 PM
external usenet poster
 
Posts: n/a
Default 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  
Old June 4th, 2004, 06:14 PM
Katrina
external usenet poster
 
Posts: n/a
Default 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  
Old June 4th, 2004, 07:43 PM
external usenet poster
 
Posts: n/a
Default 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  
Old June 4th, 2004, 08:46 PM
Katrina
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:11 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.