Rounding to nearest hundred

[MrOpine]

Not sure what happened to my original post but here it goes again......

I have a calculation that I need to perform in a query. Before I do the calculation however I need to round down numbers to the nearest hundred so a number like 1485.45 would be 1400, something like 543 would be 500 and something like 68 would be 0.

In excel this is easy for me to do using the following formula/function:

=ROUNDDOWN(C2,1-LEN(INT(C2)))

Where cell C2 might contain something like 588 the net result is 500.

How can I acheive this in Access (query)? There doesn't appear to be a rounddown function nor a len function in access.

Any help is appreciated!

M Opine

 

[mhartman]

Hello:
Please enclosed link.
Regards
Mark
http://support.microsoft.com/kb/209996/en-us

 

[raskew]

Your title is a bit of misnomer because your examples indicate that you want to round down to the next lowest 100 (not the nearest). Having said that;

Use the \ Operator:

From the debug (immediate) window:

? (568\100) * 100
500

HTH - Bob

 

[MrOpine]

Thanks! You guys are the best!

M Opine