convert to 4 decimals places

[Guest]

I have a query that i'm doing a calculation on - what i need to do is make
return the results to 4 decimal places where the last 2 places are 00 so
currently it looks like 10.123456789 i need it to return 10.1200 - it needs
to round where applicable

 

[John Spencer]

If you have Access 2000 SP2 or later Have you taken a look at the round
function. You just round your number to 2 decimal places. The trailing
zeroes make no difference in the size of the number or the way it is stored.
You can display the additional trailing zeroes if you need to by using the
format property of the relevant controls or the format property of the
column in a query.

Round(SomeNumber,2)