Rounding to nearest .25 in calculated result

D

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
 
S

Steve Schapel

Dennis,

Does this do what you want?...

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

- Steve Schapel, Microsoft Access MVP
 
D

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
Click to expand...

.
Click to expand...
 
Top