Average 1

[ptrifile]

I have a simple query that shows quality scores. What i am trying to accomplish is get an average of all of the quality scores from this query so i can display it on a form. The following only shows me the average for each individual record. Can someone please steer me in the right direction? thanks in advance!

Paul

SELECT TblMain.Mdate, TblMain.userid, TblMain.TotalScore, Avg(TblMain.TotalScore) AS AvgOfTotalScore
FROM TblMain
GROUP BY TblMain.Mdate, TblMain.userid, TblMain.TotalScore
HAVING (((TblMain.Mdate) Between forms!frmemployee!eqsdate And forms!frmemployee!eqsend) And ((TblMain.userid)=forms!frmemployee!employeeid));

 

[SkipVought]

SELECT TblMain.userid, Avg(TblMain.TotalScore) AS AvgOfTotalScore

FROM TblMain

where (((TblMain.Mdate) Between forms!frmemployee!eqsdate And forms!frmemployee!eqsend) And ((TblMain.userid)=forms!frmemployee!employeeid))

GROUP BY TblMain.userid;

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[ptrifile]

That worked fantastically! Thanks Skip!

 

[PHV]

get an average of all of the quality scores

SELECT Avg(TotalScore) AS AvgOfTotalScore
FROM TblMain
WHERE Mdate Between forms!frmemployee!eqsdate And forms!frmemployee!eqsend And userid=forms!frmemployee!employeeid

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886