Division in Access 2007-2010

[Jamie]

Simple division, I thought! I'm dividing a Sum of hours by Pay Periods to determine the average of missing hours for year-to-date. Most of the division works perfectly, and some doesn't and appears to be related to values of 1 or less than one.

The formula: [Sum]/[Pay Periods]

Sum relates to total missing hours and pay periods are total pay periods for the year so far.

What comes out wrong:

1 (hr) / 12 (pay periods) = 8.33, when it should be .0833
0.5 / 12 = 4.166 when it should be .0416

What is right is everything else, starting with 1.5 hrs

1.5 / 12 = 0.125

What do I need to do to make all of the values divide correctly?

Thanks!

 

[pr2-eugin]

Try wrapping it in Round function like,

Round([Sum]/[Pay Periods], 10)

 

[Jamie]

Thank you so much, that worked perfectly!!!!

 

[pr2-eugin]

Glad you have it working now. Good luck.