Group and Sum with two decimal places

[Welshbird]

I have a table with two codes and a value as a number with two decimal places.

When I group by the codes and sum the figures I always get results which have more decimal places.

Am I being daft? (Be kind when you answer that!) Surely a lot of numbers with two decimal places can only ever add up to an answer with two decimal places?

Any ideas guys?

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]

 

[PHV]

Floating point numbers (Single or Double) are only approximations.
You may try this:
SELECT code, Round(Sum(figure),2) AS Total
FROM theTable
GROUP BY code

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Welshbird]

Yeah - I have done that, but it can still give me a penny out.

What I don't understand is that I am importing a figure from a flat file with two decimal places. So originally it really did have two decimal places.

Would I get an accurate answer if I import as integers and do all the calculations as integers (and just divide by 100 at the end)

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]