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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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...
 
Back
Top