too many decimal places in crosstab query results

[lshippee]

I've done a crosstab query to present the averages of numeric responses to a survey.&nbsp;&nbsp;Though the decimal places property for the field being used for averaging is set to 2 in the table, the query results show up with many additional places in the crosstab.&nbsp;&nbsp;The field property was originally set to auto -- I changed it after viewing the results in the crosstab.<br><br>Do I need to recreate either the crosstab or the select query upon which it is based or is there some other way to adjust these results so they consistently show 2 decimal places?

 

[jlnewbie]

I have had the same problem, ie query calculations returning too many decimal places. What worked for me was to us Format([MyField]]&quot;0.0000&quotor Format (Calcalcuation)&quot;0.0&quot;. Placing as many zeros as you need after the decimal point. Hope that works for you