Hello all,
I am trying to round for the first time in a query...
and would like to have the query round to the nearest quarter hour...
Example date:
Hours
1.16
2.73
6.40
Desired results:
1.25
2.75
6.50
to have the hours worked rounded to the nearest quarter hour. Up or Down...
Thanks in advance for the help...
John
I am trying to round for the first time in a query...
and would like to have the query round to the nearest quarter hour...
Example date:
Hours
1.16
2.73
6.40
Desired results:
1.25
2.75
6.50
to have the hours worked rounded to the nearest quarter hour. Up or Down...
Thanks in advance for the help...
John