Rounding in access 97

[Guest_imported]

If I want to use the round function in excel in access i.e round (A1,2). What is the equivalent in Access? there is rnd but that dosen't seem to let you specify decimal places. Thanks.

 

[RJFost]

Try the Format() function- but be advised that it returns a string-type Variant [which may or may not matter to what you're doing].

 

[mikey69]

To be absolutely certain that you get the correct rounding you need to use the int function. If you want to round to two places the syntax is Int(Yournumber*100)/100.