running report in access, brings a message warning Overflow?

D

Donna.K.

I've created a report in access and when i go to run it, a warning message
comes up saying Overflow. I can't work out what this means. If i take out
some of the formulas, it seems to be ok and run. This is a minimal report,
only has a few fields in it. Some of the other reports contain alot more
formulas. So I can't see the problem.
 
D

Donna.K.

I've worked out that its something to do with the average formula.
but i'm not sure what, but when the average formula is in the report the
message appears, when i take it out the report runs

Report looks as so

WP Legal entity Invoicing DSO InvTotal
(Invoicing*DSO)
£123465 81
10000665
£496832 78 38752896
Total £620297 39753561

Average =sum([InvTotal])/sum([Invoicing])
 
D

Duane Hookom

Do you have any records in the report where Sum(Invoicing) might be 0?

--
Duane Hookom
MS Access MVP


Donna.K. said:
I've worked out that its something to do with the average formula.
but i'm not sure what, but when the average formula is in the report the
message appears, when i take it out the report runs

Report looks as so

WP Legal entity Invoicing DSO InvTotal
(Invoicing*DSO)
£123465 81
10000665
£496832 78
38752896
Total £620297
39753561

Average =sum([InvTotal])/sum([Invoicing])

Donna.K. said:
I've created a report in access and when i go to run it, a warning
message
comes up saying Overflow. I can't work out what this means. If i take out
some of the formulas, it seems to be ok and run. This is a minimal
report,
only has a few fields in it. Some of the other reports contain alot more
formulas. So I can't see the problem.
Click to expand...
Click to expand...
 
Top