Rounding an average

[Digger442]

I am running a query that returns the minimum, maximum, and average mileage of a list of cars. I have set decimal places to zero in all places I can think of, but of course the average returns with a long decimal output. These figures are then displayed on a report.

How can I truncate the 'average' display so it rounds to show no decimals?

I have tried using Round([YourNumberFieldName],3) in the query but that doesn't seem to work.

The numbers are stored in a table as double numbers. Again the decimal places are set to 0.

Thanks.

 

[WayneRyan]

Digger,

Try --> Round(Avg([YourNumberFieldName]),3)

You can also have the report format the value instead.

Wayne

 

[Digger442]

Wayne,

Thanks! That worked perfect. Now all I have to do is glue my hair back in place!

Greatly Appreciated