Rounding the Average in a Query

[jakelufkin]

I am trying to average a score and have it round to 2 decimal places. I'm not sure what I'm doing wrong.

This is my syntax:

SELECT Evaluations.team, Avg(Round([introduction],2)) AS Introduciton
From Evaluations
Group BY Evaluations.team

The result is

Team 1...2.6
Team 2...2
Team 3...2.375
Team 4...2.2666666666667

Any help would be appreciated.

Thanks!
~jakelufkin

[thhui]

Converted to:-

SELECT Evaluations.team, round(avg([introduction]),2) AS Introduciton
From Evaluations
Group BY Evaluations.team

[jakelufkin]

Very much appreciated, Thanks!

[thhui]

Glad to see your posting back with success!

If your issue is resolved, may you use this forum's thread tools feature to mark it solved.