How to round a field to the hundreds place

  • Thread starter Thread starter Dan S.
  • Start date Start date
D

Dan S.

I have a query where I'm getting aggregate data (count,
sum) of two fields. I am wanting to group by current
balance, rounded to the nearest hundreds place. So, in
other words, I want the count and sum of all accounts of
$50 to $149.99 (rounds to $100), $150 to $249.99 (rounds
to $200), and so on. I saw the Round function, but it
appears to only round decimals.

Any help is greatly appreciated.



Thanks,

-Dan.
 
Dan,

Divide your original number by 100, use the Round function and then multiply
by 100:

=100*(Round([Amount]/100))

HTH,
Nikos
 
Back
Top