rounding an average values

[Lifeseeker]

Hi there,

I'm trying to get this query to work:

SELECT Avg(Round([Final 205].[LastOfSumOfRehLOS],2)) AS AvgInpLOS, Avg(Round([LastOfSumOfWaitLOS],1)) AS AvgWaitTime, Count([Final 205].PHN) AS Observations, [Final 205].LastOfIntensity AS Intensity_Level
FROM [Final 205]
GROUP BY [Final 205].LastOfIntensity;

It doesn't found the result to two decimal places.

Anybody can help?

thanks

 

[Galaxiom]

You are averaging numbers that have been rounded.

You need to round the result.