Rounding the results within a query

[Joozh]

Hi,

I am running a query which is giving results with 4 decimal places. How can I modify the query so that the column in question displays the results with 2 decimal places? I could not find the ROUND function...

Your help would be appreciated.

Kind Regards,

Zargham

 

[dk]

Round will work e.g.

SELECT Round(MyTable.MyField,2) blah blah

 

[MSOfficeuser]

I right-click the relevant field in design view and select "Properties." In that list, you can specify the decimal places. I use 0 to get the result in integers.
This message was edited by MSOfficeuser on 2003-01-25 23:09