Round up to hundreds into a query

[matteozz]

Hello everyone!


I'm really in a bind. Basically I built a query in which there are some formulas that generate data, they make very simple calculations. At the end I get a result but I want to round up to the hundreds automatically: 60 becomes 100, 110 becomes 200, 150 becomes 200, 5201 became 5300 and so on ...

Thank you for help!

[CJ_London]

try

(int(myvalue/100)+1)*100

[matteozz]

Thanks! It runs! I also post another formula

=INT((Value/100 + 0.99))*100

[ssanfu]

FYI, "Value" is a reserved word in Access and shouldn't be used as object names. (which is why Paul used "myvalue")

For a list of reserved words, see http://www.allenbrowne.com/AppIssueBadWord.html