Query Sum Function Decimal Precision

[Stukmeister]

I have the following query:

SELECT ProjectTime.ProjectTimeProjectTaskID,
Sum(ProjectTime.ProjectTimeActualHours) AS SumOfProjectTimeActualHours
FROM ProjectTime
GROUP BY ProjectTime.ProjectTimeProjectTaskID;

ActualHours is defined as
Field Size = Single
Format = Fixed
Decimal Places = 1

I enter one record with .4 keyed into ActualHours and when I run the sum
query I get an answer of 0.400000005960464

I know that I can round it. But why is the sum not returned as .4?

 

[KARL DEWEY]

Not only do you set the field definition but you need to set the display
format in the query, form, and report.

 

[S.Clark]

When Microsoft Access Math Doesn't Add Up
By Luke Chung, President
FMS, Inc.

http://www.fmsinc.com/tpapers/math/index.html