Currency Error on decimal

[labcheung]

Hi all:

I am working on Access 2000 with SP3. The problem is the sum of currency has
$0.01 difference on the total even I use the same equation on all forms.

I have a product which costs $538.20, then add two taxes (7% ---$37.67 and
6% ---$32.29) and the total amount should be $608.16.

Total=Subtotal (1 + Tax1 +Tax2) all controls are formated as currency.
$608.16 = $538.20 + $37.67 + $32.29

The problem is some forms show $608.16 but other show $608.17.

Any suggestions

Thank you

[Tom van Stiphout]

On Wed, 31 Jan 2007 06:24:22 GMT, "labcheung" <la*******@yahoo.com>
wrote:

Put the same calculation in Excel, and change the number of decimals
to many. That will show you why it's working the way it is.
The solution is to round to two decimals before you add, perhaps using
the Round function or some other more specialized rounding function.

-Tom.

>Hi all:

I am working on Access 2000 with SP3. The problem is the sum of currency has
$0.01 difference on the total even I use the same equation on all forms.

I have a product which costs $538.20, then add two taxes (7% ---$37.67 and
6% ---$32.29) and the total amount should be $608.16.

Total=Subtotal (1 + Tax1 +Tax2) all controls are formated as currency.
$608.16 = $538.20 + $37.67 + $32.29

The problem is some forms show $608.16 but other show $608.17.

Any suggestions

Thank you

[Lab]

Thank you very much, Tom.

I take your advise with "Round" function and everything goes back to normal

Lab
"Tom van Stiphout" <no*************@cox.netwrote in message
news:tj********************************@4ax.com...

On Wed, 31 Jan 2007 06:24:22 GMT, "labcheung" <la*******@yahoo.com>
wrote:

Put the same calculation in Excel, and change the number of decimals
to many. That will show you why it's working the way it is.
The solution is to round to two decimals before you add, perhaps using
the Round function or some other more specialized rounding function.

-Tom.

>>Hi all:

I am working on Access 2000 with SP3. The problem is the sum of currency
has
$0.01 difference on the total even I use the same equation on all forms.

I have a product which costs $538.20, then add two taxes (7% ---$37.67
and
6% ---$32.29) and the total amount should be $608.16.

Total=Subtotal (1 + Tax1 +Tax2) all controls are formated as currency.
$608.16 = $538.20 + $37.67 + $32.29

The problem is some forms show $608.16 but other show $608.17.

Any suggestions

Thank you