OverFlow

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I got a message "overflow" when I tried to input the percente into the
textfield on the report. this is my fomula from source
=avg([EFCase]/[PageCase])


Thank you for help.
 
One of the value is equal tp 0
you get that message when you devide by 0
check for 0 and null
 
I'm inclined to think that the field that is to receive the result of this
formula is defined as an Integer or Long. Change it to a larger datatype,
maybe a Single or Double.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Thank you for responds, I did change from Integer to signle or double but it
still give me the overflow. Is there any fomula to make it works? thank you
very much
I used avg([ERCases]/[Nocases]) it works if data doesn't contain the 0.
Graham R Seach said:
I'm inclined to think that the field that is to receive the result of this
formula is defined as an Integer or Long. Change it to a larger datatype,
maybe a Single or Double.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

DeeNg said:
I got a message "overflow" when I tried to input the percente into the
textfield on the report. this is my fomula from source
=avg([EFCase]/[PageCase])


Thank you for help.
Click to expand...
Click to expand...
 
Well. if it works when the data is non-zero, the following may help:

IIf(Nz([ERCases], 0) + Nz([NoCases], 0) = 0, 0, Avg([ERCases] / [NoCases]))

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

DeeNg said:
Thank you for responds, I did change from Integer to signle or double but
it
still give me the overflow. Is there any fomula to make it works? thank
you
very much
I used avg([ERCases]/[Nocases]) it works if data doesn't contain the 0.
Graham R Seach said:
I'm inclined to think that the field that is to receive the result of
this
formula is defined as an Integer or Long. Change it to a larger datatype,
maybe a Single or Double.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

DeeNg said:
I got a message "overflow" when I tried to input the percente into the
textfield on the report. this is my fomula from source
=avg([EFCase]/[PageCase])


Thank you for help.
Click to expand...
Click to expand...
Click to expand...
 
Thank you it works.

Graham R Seach said:
Well. if it works when the data is non-zero, the following may help:

IIf(Nz([ERCases], 0) + Nz([NoCases], 0) = 0, 0, Avg([ERCases] / [NoCases]))

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

DeeNg said:
Thank you for responds, I did change from Integer to signle or double but
it
still give me the overflow. Is there any fomula to make it works? thank
you
very much
I used avg([ERCases]/[Nocases]) it works if data doesn't contain the 0.
Graham R Seach said:
I'm inclined to think that the field that is to receive the result of
this
formula is defined as an Integer or Long. Change it to a larger datatype,
maybe a Single or Double.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------


I got a message "overflow" when I tried to input the percente into the
textfield on the report. this is my fomula from source
=avg([EFCase]/[PageCase])


Thank you for help.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top