Hello,
I am building a query from my table(Table1) and I have records of number of hours worked in a fixed number format. I want to add them all up to a total but when I use the count option in the group by it just adds them to a whole number. I want to keep the 2 decimal places. Can you do this with the DCount function or is there a better way? thanks