ROUND function in Access 97

[dbadmin]

Hi,

I am using Access 97 and it doesn't allow using ROUND function. I was trying to use int function in SQL query instead and cannot get the correct syntax to get the numbers corrected to 3 decimal places. My tables columns looks like this

10.34500008
9.757634
8.73902

I want the output to be

10.345
9.758
8.739

Any help is really appreciated

dbadmin

 

[PHV]

Have you tried Format([name of field], "#.###") ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[cheerio]

Try INT(1000 * x + 0.5)/1000

eg INT(9.757634 * 1000 + 0.5)/1000
= INT(9757.634 + 0.5)/1000
= INT(9758.134)/1000
= 9758/1000
= 9.758

 

[dbadmin]

Thanks a lot! You all rock.

dbadmin

 

[dbadmin]

Thanks guys. Cheerio, you rock....