VBA Function 2 decimal places

[ijswalker]

I have a query in Microsoft Access 2010. A couple of columns have a number that needs converted to 2 decimal places. This means that the number to convert will be a variable depending on the value in the column. Can anyone help me create this function.

Thanks

Ian

 

[CJ_London]

do you want to convert it to 2 dp's or just format to 2 dp's.

If format you use

format(mynumber,"0.00")

if convert you use

round(mynumber,2)

 

[namliam]

Or you can place a format on the column to only display the 2 decimal points.