sherlocked
Registered User.
- Local time
- Today, 12:17
- Joined
- Sep 22, 2014
- Messages
- 125
Hi Experts,
I have a report based on the below query. This pulls my records just fine into a report.
SELECT Avg(tblScoring.NScore) AS AvgOfNScore, Avg(tblScoring.MScore) AS AvgOfMScore, Avg(tblScoring.IScore) AS AvgOfIScore, tblScoring.Nominee, tblScoring.AwardType, tblScoring.AwardYear
FROM tblScoring
GROUP BY tblScoring.Nominee, tblScoring.AwardType, tblScoring.AwardYear
HAVING (((tblScoring.AwardYear)=DatePart("yyyy",Date())))
However, I am trying to sort my report on the following expression: =Sum([AvgOfNScore]+[AvgOfMScore]+[AvgOfIScore])
For some reason I cannot determine, the report will not sort correctly.
Any thoughts as to how I can accomplish this? I cannot add the calculation to my query because it is an aggregate.
Thank you in advance for any assistance you can provide!
I have a report based on the below query. This pulls my records just fine into a report.
SELECT Avg(tblScoring.NScore) AS AvgOfNScore, Avg(tblScoring.MScore) AS AvgOfMScore, Avg(tblScoring.IScore) AS AvgOfIScore, tblScoring.Nominee, tblScoring.AwardType, tblScoring.AwardYear
FROM tblScoring
GROUP BY tblScoring.Nominee, tblScoring.AwardType, tblScoring.AwardYear
HAVING (((tblScoring.AwardYear)=DatePart("yyyy",Date())))
However, I am trying to sort my report on the following expression: =Sum([AvgOfNScore]+[AvgOfMScore]+[AvgOfIScore])
For some reason I cannot determine, the report will not sort correctly.
Any thoughts as to how I can accomplish this? I cannot add the calculation to my query because it is an aggregate.
Thank you in advance for any assistance you can provide!