Prev: Right-Align Field When Exporting to Text
Next: Date format
From: slotmgr70 on 22 Jan 2010 21:47
How do I round a number to the nearest 5?

121.23 = 120
123.45 = 125
1456.19 = 1455

Any suggestions?
From: Allen Browne on 22 Jan 2010 22:00
See:
http://allenbrowne.com/round.html#Round5c

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"slotmgr70" <slotmgr70(a)discussions.microsoft.com> wrote in message
news:9598ECEC-FA77-4545-B5E9-6F6D3D9D860F(a)microsoft.com...
> How do I round a number to the nearest 5?
>
> 121.23 = 120
> 123.45 = 125
> 1456.19 = 1455
>
> Any suggestions?

From: slotmgr70 on 23 Jan 2010 11:59
got it. Thanks!

"Allen Browne" wrote:

> See:
> http://allenbrowne.com/round.html#Round5c
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
>
> "slotmgr70" <slotmgr70(a)discussions.microsoft.com> wrote in message
> news:9598ECEC-FA77-4545-B5E9-6F6D3D9D860F(a)microsoft.com...
> > How do I round a number to the nearest 5?
> >
> > 121.23 = 120
> > 123.45 = 125
> > 1456.19 = 1455
> >
> > Any suggestions?
>
> .
>
 | 
Pages: 1
Prev: Right-Align Field When Exporting to Text
Next: Date format