Set the number of decimal places to display for a field in query Design view

1. Open a query in Design view.
   
   
2. In the query design grid, place the insertion point in the column for the field you want to change. You can place the insertion point in any row for that field.
   
   
3. Click Properties on the toolbar to open the property sheet for that field.
   
   
4. On the General tab, click the arrow next to the DecimalPlaces property box, and then click the desired number of decimal places.

   The DecimalPlaces property provides a default setting, Auto, and the option to specify from 0 to 15 decimal places. When set to Auto, fields with Format property settings of Currency, Fixed, Standard, Percent and Scientific display two decimal places. The DecimalPlaces property has no effect if the Format property hasn't been set. For information on setting a field's data display format, click .

Note   The DecimalPlaces property setting affects only the number of decimal places that display, not how many decimal places are stored. For example, if you set the DecimalPlaces property to 2 for a Number field with the FieldSize property set to Integer, it will display with two decimal places, but because only whole number (integer) values will be stored, zeros will fill the two decimal places. To change the number of decimal places that will be stored, you must change a Number field's FieldSize property. For information on setting a field's FieldSize property, click