running report in access, brings a message warning Overflow?

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

Guest

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.
 
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])
 
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...
 
Back
Top