Issue of pennies

Hi

I have this problem on report that the total is out by a penny and client is
complaining. Like below;

Net £334.31
Vat £58.50
Total £392.82

How can I fix it so calculations seem correct to the second decimal?

Thanks

Regards

On Mar 1, 3:16 pm, "John" wrote:
Hi

I have this problem on report that the total is out by a penny and client is
complaining. Like below;

Net £334.31
Vat £58.50
Total £392.82

How can I fix it so calculations seem correct to the second decimal?

Thanks

Regards

Perhaps:

http://groups.google.com/group/comp....b62fc73ccf04d8

James A. Fortune

On Mon, 1 Mar 2010 20:16:24 -0000, "John" wrote:

Hi

I have this problem on report that the total is out by a penny and client is
complaining. Like below;

Net £334.31
Vat £58.50
Total £392.82

How can I fix it so calculations seem correct to the second decimal?

Thanks

Regards


A Currency datatype has four decimals, even when only two are shown; if you're
using a Single or Double (not the best idea) there will be even more.

I'd suggest wrapping the calculation in a call to the Round() function. You
don't say how the calculation is done but it might be something like setting
VAT to

Round([Net] * [VATRate], 2)

adapted to your situation.
--

John W. Vinson [MVP]

,;,;v;,hv;

"John" a écrit dans le message de groupe de
discussion : ...
Hi

I have this problem on report that the total is out by a penny and client
is complaining. Like below;

Net £334.31
Vat £58.50
Total £392.82

How can I fix it so calculations seem correct to the second decimal?

Thanks

Regards