M mh Jan 18, 2008 #1 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,
J John W. Vinson Jan 18, 2008 #2 In an Access Report how do i round to the nearest multiple? ex. 45263 Round to 45260 45266 Round to 45270 Thanks, Click to expand... Multiple of 10? 10*Round([field]/10,0) John W. Vinson [MVP]
In an Access Report how do i round to the nearest multiple? ex. 45263 Round to 45260 45266 Round to 45270 Thanks, Click to expand... Multiple of 10? 10*Round([field]/10,0) John W. Vinson [MVP]
A Allen Browne Jan 19, 2008 #3 There's a bunch of rounding info here: http://allenbrowne.com/round.html#RoundNegativePlaces
