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!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round decimal number in calculated fields 2
Dcount returning no results!!! 0
Subtracting "Settle_Date" from "Deal_Date", how many days ? 8
Pivot Table rounding 3
Rounding errors 8
Rounding Question 3
ROUNDING QUESTION 1
Formula dilema 3

Back
Top