Average (1 Viewer)

[ecuevas]

I have a query that finds an average. How can I get the average to only show two numbers after the decimal?

 

[MStCyr]

Take a look at the Format command

 

[ecuevas]

I am using this average on a report. In Design View I double clicked the text box and changed Decimal Places to 2 but it still gives me 7 numbers after the decimal.

 

[mhartman]

Hello:

Here is a example of what MStCyr was referring to:

Run the report. In design mode notice the Format property setting.

Regards
Mark

 

[mhartman]

Also: see attachment