Rounding to nearest .25 in calculated result

[Dennis Doll]

Hi,

I'm trying to round a sum in a report to the nearest
quarter, or .25. I suspect there's some easy language for
this, but it escapes me. Any help?

Thanks in advance,

Dennis

 

[Steve Schapel]

Dennis,

Does this do what you want?...

=Int([YourField] * 4 + 0.5) / 4

- Steve Schapel, Microsoft Access MVP

 

[Dennis]

I think so!
I actually worked it out similarly like this:
=Int(([MyField]+.125) * 4) / 4

which is the same thing, only less elegant.

Thanks,

Dennis

-----Original Message-----
Dennis,

Does this do what you want?...

=Int([YourField] * 4 + 0.5) / 4

- Steve Schapel, Microsoft Access MVP

Hi,

I'm trying to round a sum in a report to the nearest
quarter, or .25. I suspect there's some easy language for
this, but it escapes me. Any help?

Thanks in advance,

Dennis

.