Sum totals not rounding up?

J

Joe

Hello,

I have an hours worked field in one of my tables.I tried
to run a report and the results are :

5.30
2.00
.30
 
C

Cheval

I'd hate to be Captian Obvious, but it's because you have
set it to 2 decimal places. Set it to Zero.

A better answer would be in the report query source, in
the hours field have it be "SELECT CInt(Hours) as Hours1
FROM tbl.." etc.
 
Top