Round to the nearest half hour

[Guest]

I am making a query where I divde a field in my query (Week Hours) divided by
5 to get Daily Hours. I would like that number to be rounded to the nearest
half hour.

Example: 2.01-2.24=2
2.25-2.74=2.5
2.75-2.99=3

Any help would be greatly appreciated!

 

[Michel Walsh]

Hi,



0.5 * INT( 0.5+ value / CDec(0.5) )


Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

I used what you give me, 0.5*INT(0.5+[Week Hours]/CDec(0.5)), and it told me
"The expression you entered has a function containing the wrong number of
arguments."

 

[Michel Walsh]

Hi,

The dot is decimal, not a list delimiter?


In the immediate (debug) window (Ctrl_G), try :

? 0.5* INT( 0.5 + 3.212 / CDec(0.5) )




It should return 3.


Hoping it may help,
Vanderghast, Access MVP

I used what you give me, 0.5*INT(0.5+[Week Hours]/CDec(0.5)), and it told
me
"The expression you entered has a function containing the wrong number of
arguments."

Hi,



0.5 * INT( 0.5+ value / CDec(0.5) )


Hoping it may help,
Vanderghast, Access MVP