Rounding to nearest .25 in calculated result

  • Thread starter Thread starter Dennis Doll
  • Start date Start date
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
 
Dennis,

Does this do what you want?...

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

- Steve Schapel, Microsoft Access MVP
 
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...
 
Dennis,

Elegance is apparently in the eye of the beholder. Glad you've got
it.

- Steve Schapel, Microsoft Access MVP
 
Back
Top