Problem in the sum of two double number

[nello87to]

Hi,
I have a sub routine in a script of my access DB that perform the calculation between two double numbers.
This is the instruction:

matrix(r, c) = matrix(r, c) + importo

matrix is defined as 'Dim matrix(23, 5) As Double'
and importo is a parameter value 'Sub SommaImporti(colonnaSomma, importo, t)'

The calculation works well, but at one point I have this:
74390632,95 + 6255,5 = 74396888,45
74396888,45 + 90945,17 = 74487833,62
74487833,62 + 43855,12 = 74531688,7400001
74531688,7400001 + 24311,37 = 74556000,1100001
74556000,1100001 + 44099,73 = 74600099,8400001
74600099,8400001 + 2551,62 = 74602651,4600001



I don't understand why the sum of 74487833,62 + 43855,12 returns 74531688,7400001

What could be the mistake?

Thanks,
Nello

[pbaldy]

Well, Double is a floating point data type so it can represent values that way. I'd say use Currency but it only handles 4 decimals, so maybe try Decimal? If it's not a VBA data type, then you're probably looking at converting values and using Int().