rounding averages

[alex]

i've got a query that displays a list of turnaround times,
and then averages those figures (thank you, Marsh!).
currently this average is displaying with numerous decimal
places, how can i change this to just show 2? i've tried
right clicking in the text box, selecting properties, and
changing the decimal places to 2, but this isn't working
(when i leave design view, the report is still displaying
the numerous decimal places, and when i go back into
properties the decimal place field has reverted back to
Auto). i know this is just a cosmetic issue, but it's
bugging me! any suggestions?

 

[Jeff Boyce]

Alex

Have you opened the report and changed the format on the control there?

Good luck

Jeff Boyce
<Access MVP>

 

[alex]

i'm not sure how to do that, i thought changes to the
report needed to be done in design view.

 

[Jeff Boyce]

Alex

Yes, they do. But your earlier post mentioned changing the query, not the
report, right?

Jeff Boyce
<Access MVP>

 

[alex]

no...the query generates the figures (which are displayed
with two decimal places), but the average is only
calculated in the report.