how do I limit the number of decimal places in Access 2003?

N

NoviceIan

I have a query that calculates the average milage of our staff members which
displays 8 decimal places. I only want 2 decimal places and I've tried to
change the properties but it still displays 8 decimal places.

How can I alter this?

Ian
 
V

Van T. Dinh

In the DesignView of the Query, right-click on the required Column and
select Properties. In the Properties Dialog, set the required format for
the Column / Field, e.g. 0.00.
 
N

NoviceIan

Thanks very much thats been bugging me all day.

Van T. Dinh said:
In the DesignView of the Query, right-click on the required Column and
select Properties. In the Properties Dialog, set the required format for
the Column / Field, e.g. 0.00.
Click to expand...
 
Top