Calculation Problem

[Ryan]

I have a form based on a query. In the forms footer I have a field
[GTotalHours] with a control source of =Sum([Hours]). For some reason
[GTotalHours] will not calculate anything after the decimal. For example.

1.1
2.3
5.4

The answer should be 7.8, but I only get 7. I have tried everything,
changing the format of the field in the query to fixed with 2 decimals,
standard, and currency. Then I tried changing the format in the table. I
have run a summary query and it totals correctly in the summary query, but I
cant get it to work otherwise. Please help.

 

[Jeff Boyce]

Ryan

I'm guessing that something somewhere is either defined as an Integer,
formatted as an Integer, or has defaulted to be an Integer.

Regards

Jeff Boyce
Microsoft Office/Access MVP