Rounding Problem

  • Thread starter Thread starter michael c
  • Start date Start date
M

michael c

I have a table, tblWorkingDays, that has these fields:
Date,Adjustment,Holiday
Where Adjustment is either 1 or 0.5 and is a Double data
type.

I have a query that is counting the number of Adjustments
(Holidays) in each month, but it rounds up all of the sums
even if I put a 1 in the column's decimal property. Any
thoughts? Thanks!!
 
Back
Top