Rounding - How 1

[wally2321]

Can some one help me please? I am creating a query using the design feature. The problem is the number I am loading has 8 digits past the decimal whereas I only want two places. The second digit past the decimal should be rounded up or down, depending on the number.

Is there a good way to do that in MS Access

 

[DougP]

format may work

=format(yournumber,"###.00&quot DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[braindead2]

rightclick on the field you want rounded. this will pop up a menu. click on properties set your format to fixed and decimal places to 2
good luck

 

[kjc]

If you really want to "trim" off the excess decimal places, use this:

Function RoundCC(X)
RoundCC = Int(X * Factor + 0.5) / Factor
End Function

Use it like MyNumber = RoundCC(MyNumber)

 

[JoeMiller]

KJC,

You forgot to mention that he'll need to place:

Const Factor = 100

in the module so that Factor is a known number. To change the number of decimal places, modify the factor. IE:

3 decimals, Const Factor = 1000
4 decimals, Const Factor = 10000

etc...

HTH Joe Miller
joe.miller@flotech.net