Is there an INT() type of function?
If so, multiply by 10^ndecimals, add 0.5, divide by 10^ndecimals and use that INT()-type function.
Joe
>Hi all,
>
>Sorry to post this question here but it's the only place I've found help for silly little things I can do easily in VFP but not in Access 97.
>
>Can anyone tell me how to round my results in a query to one or two decimal places? I thought there would be a ROUND(
,) sort of thing but apparently not.
>
>For example, I want 3.27569 to be rounded to 3.3
>
>Does anyone know how this can be accomplished in Access '97?
>
>Thanks much!
>
>-JT
Joseph C. Kempel
Systems Analyst/Programmer
JNC