Problem with format of number

[Bioman]

I have a table 'item' who contains the name of the item and the price. The format of price is standard with 2 decimals. In a form I have one item and I do a sum of this item (sometime there is many item). When I have high number like 471 219.70 the sum of this number is 471 219.66... Why?!? I have Access 97, the format of my number is same everywhere

 

[David R]

Try Formatting as Currency. Access has some weird rounding errors.

 

[Bioman]

I don't want to use currency because sometime the currency is not dollar

 

[David R]

Search support.microsoft.com for Access (your version), "rounding".

Good luck,
David R