limiting decimals in query results

[IR Analyst]

I have a query that gives me the correct average dollar amount, but it gives
me way too many decimal places. Just to make the query look nice and neat, I
would like like to limit the number of decimals. So instead of seeing
2802.6911236454 as the AvgofSumofAmount, I would like the query to give me
2802.69. Can anyone help me? Thanks in advance!

 

[Jerry Whittle]

TheAverage: Format([SumofAmount], "0.00")

 

[Marshall Barton]

I have a query that gives me the correct average dollar amount, but it gives
me way too many decimal places. Just to make the query look nice and neat, I
would like like to limit the number of decimals. So instead of seeing
2802.6911236454 as the AvgofSumofAmount, I would like the query to give me
2802.69.

You should not care what the value looks like in the query's
datasheet view. Setting the Format property of the
form/report text box that displaye the value is a more
appropriate way to do things.

If you really feel the urge to format the query's datasheet,
you can set the field's Format property to Currrency or 0.00