Calculation Problem

  • Thread starter Thread starter Ryan
  • Start date Start date
R

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.
 
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
 
Back
Top