 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / January 2008Round to a Multiple
In an Access Report how do i round to the nearest multiple? ex. 45263 Round to 45260 45266 Round to 45270 Thanks, >In an Access Report how do i round to the nearest multiple? > >ex. 45263 Round to 45260 > 45266 Round to 45270 > >Thanks, Multiple of 10? 10*Round([field]/10,0) John W. Vinson [MVP] There's a bunch of rounding info here: http://allenbrowne.com/round.html#RoundNegativePlaces  SignatureAllen 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. > In an Access Report how do i round to the nearest multiple? > > ex. 45263 Round to 45260 > 45266 Round to 45270 > > Thanks, |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.