Rounding a number in a query

[libraccess]

I have this query which is for a chart where the number is displayed. I have tried to eliminate the decimal points for an average but no joy. Apart from that the charts work OK Where am I going wrong please?



SELECT (Format([DateMain],"mmm"" '""yy")) AS Expr1, Avg(Round([DelVol],1)) AS Expr2, Sum(qryChartDelivCount.CountOfDelVol) AS SumOfCountOfDelVol, qryChartDelivCount.DestinationFROM qryChartDelivCount
GROUP BY (Format([DateMain],"mmm"" '""yy")), qryChartDelivCount.Destination, (Year([DateMain])*12+Month([DateMain])-1)
HAVING (((qryChartDelivCount.Destination)="Springfield"))
ORDER BY (Year([DateMain])*12+Month([DateMain])-1);

[pbaldy]

Try reversing the functions. You're averaging the rounded number, you want to round the average.

[libraccess]

----------, Round(Avg([DelVol]),0) AS Expr2, ---------

thanks very much

[pbaldy]

Happy to help.