Query calculation incorrect

[d000075]

Hi all

I have a query field doing a simple calculation: 874*(18,3/55,65*0,0592)
Access calculates this to: 17,0144948838454
Excel as well as my own calculator gets: 17,0144948787062
All table fields is defined as double.

If anyone can help me with an explanation as to why access doesn't seem to get this simple calculation right, I would be most thankful.

 

[chergh]

Access 2003 returns the same answer for as excel and your calculator did. Anyway your values are between 0 and 5 decimal places does a difference after the seventh decimal place really matter?

 

[MStef]

Try this:
All table fields properties:
Data type = Number, Field size = Double, Format = General Number,
Decimal places = Auto.

 

[Dennisk]

try casting the result to a double in the query.

 

[Guus2005]

replacing the comma's by points access' immediate window produces: 17,0144948787062
but the query does 17,014494879
Converting it to a double indeed: cdbl(874*(18,3/55,65*0,0592)) = 17,0144948787062