Round decimal number in calculated fields

[rama]

Hello
I am looking for some help to make a rounding adjustment in the
calculated fields in my query. What I wish to do is to round the
decimal numbers like this: >0.01 to <0.24 to 0.0, >=0.25 to <0.74 to
0.5 and >=0.75 to <1 to 1. Thanks in advance.
Rama

 

[John W. Vinson]

Hello
I am looking for some help to make a rounding adjustment in the
calculated fields in my query. What I wish to do is to round the
decimal numbers like this: >0.01 to <0.24 to 0.0, >=0.25 to <0.74 to
0.5 and >=0.75 to <1 to 1. Thanks in advance.
Rama

Double the number and round to zero decimals, then divide:

Round(2.*<your expression>, 0) / 2

 

[rama]

Double the number and round to zero decimals, then divide:

Round(2.*<your expression>, 0) / 2

This works fine. Thank you very much for the help.
Rama