round

[198311]

hello ,
how Can I to round a digit "2,3488" ??
I have a formula in SQL

Select 3.63*0.22 - and it is 0.7986
and I need only 0,79
when I show value 0.7986 in textbox in Access 97 i have 0.8 - but I need 0.79
Is this possible in Access 97 in Query ??

bye

 

[PHV]

Access 97 is far away from ANSI SQL !
you wanted this ?
Int(100*(3.63*0.22))/100

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

 

[JarlH]

Just one detail, 0.7986 *rounded* to two decimals is actually 0.80, not 0.79.