By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Reports Rounding Error

P: n/a
Hello,

I've inherited a tax report where all of the financial numbers are
currency.This is a detailed report that lists amount, tax and total for
that day ( total is listed in the database). The report gets its
information from a query. At this point all is working

Then in the report footer I am trying to total the entire amount for
that particular day. The basic formula in use is:
=Sum([TOTAL])
This works the majority of time, but on some days we will be shy a
penny or 2.

I have tried many different calculations (* 100/100, Rounding, CCur,
etc) but nothing seems to work.

I'm using ms access 2003 sp2

Any ideas would be MUCH appreciated

Dec 14 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Is the TOTAL Field in the database defined as Currency? Currency is supposed
to carry 4 decimal places, to avoid rounding errors. If you have set
"Currency" as the Format for the Control on the Report, that alone would not
prevent rounding errors.

Larry Linson
Microsoft Access MVP

<ga*******@yahoo.comwrote in message
news:11**********************@73g2000cwn.googlegro ups.com...
Hello,

I've inherited a tax report where all of the financial numbers are
currency.This is a detailed report that lists amount, tax and total for
that day ( total is listed in the database). The report gets its
information from a query. At this point all is working

Then in the report footer I am trying to total the entire amount for
that particular day. The basic formula in use is:
=Sum([TOTAL])
This works the majority of time, but on some days we will be shy a
penny or 2.

I have tried many different calculations (* 100/100, Rounding, CCur,
etc) but nothing seems to work.

I'm using ms access 2003 sp2

Any ideas would be MUCH appreciated

Dec 14 '06 #2

P: n/a
Yes TOTAL is defined as Currency.

I have tried setting all of the fields to various types and none seem
to work.

Thank you,
Carrie
Larry Linson wrote:
Is the TOTAL Field in the database defined as Currency? Currency is supposed
to carry 4 decimal places, to avoid rounding errors. If you have set
"Currency" as the Format for the Control on the Report, that alone would not
prevent rounding errors.

Larry Linson
Microsoft Access MVP

<ga*******@yahoo.comwrote in message
news:11**********************@73g2000cwn.googlegro ups.com...
Hello,

I've inherited a tax report where all of the financial numbers are
currency.This is a detailed report that lists amount, tax and total for
that day ( total is listed in the database). The report gets its
information from a query. At this point all is working

Then in the report footer I am trying to total the entire amount for
that particular day. The basic formula in use is:
=Sum([TOTAL])
This works the majority of time, but on some days we will be shy a
penny or 2.

I have tried many different calculations (* 100/100, Rounding, CCur,
etc) but nothing seems to work.

I'm using ms access 2003 sp2

Any ideas would be MUCH appreciated
Dec 14 '06 #3

P: n/a
as a follow-up,

Some of the calculations have been variations of:

CCur(CLng(Sum([TOTAL]))*100)/100)

=Sum(([TOTAL])*100+0.5)/100

Thank you

gabo22...@yahoo.com wrote:
Yes TOTAL is defined as Currency.

I have tried setting all of the fields to various types and none seem
to work.

Thank you,
Carrie
Larry Linson wrote:
Is the TOTAL Field in the database defined as Currency? Currency is supposed
to carry 4 decimal places, to avoid rounding errors. If you have set
"Currency" as the Format for the Control on the Report, that alone would not
prevent rounding errors.

Larry Linson
Microsoft Access MVP

<ga*******@yahoo.comwrote in message
news:11**********************@73g2000cwn.googlegro ups.com...
Hello,
>
I've inherited a tax report where all of the financial numbers are
currency.This is a detailed report that lists amount, tax and total for
that day ( total is listed in the database). The report gets its
information from a query. At this point all is working
>
Then in the report footer I am trying to total the entire amount for
that particular day. The basic formula in use is:
=Sum([TOTAL])
This works the majority of time, but on some days we will be shy a
penny or 2.
>
I have tried many different calculations (* 100/100, Rounding, CCur,
etc) but nothing seems to work.
>
I'm using ms access 2003 sp2
>
Any ideas would be MUCH appreciated
>
Dec 15 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.