Need Help on AVG Query

  • Thread starter Thread starter scottyp1967
  • Start date Start date
S

scottyp1967

I have a query in Access 2000 that returns the following info:

Employee Week Efficiency
A 1 85
B 1 87
C 1 93
A 2 91
B 2 80
C 2 100
A 3 79
B 3 58
C 3 70

I need the total average efficiency for all 3 employees for each week,
all the way through week 52. So, my new query would return the
following:

Week Total Efficiency
1 88.3
2 90.3
3 69

How do I find the total efficiency using a query?

Thanks in advance.
 
I have a query in Access 2000 that returns the following info:

Employee Week Efficiency
A 1 85
B 1 87
C 1 93
A 2 91
B 2 80
C 2 100
A 3 79
B 3 58
C 3 70

I need the total average efficiency for all 3 employees for each week,
all the way through week 52. So, my new query would return the
following:

Week Total Efficiency
1 88.3
2 90.3
3 69
Click to expand...


SELECT Week, Avg(Efficiency) As TotalEfficiency
FROM yourquery
GROUP BY Week
 
Create a totals query based on your "query in Access" that groups by Week
and averages Efficiency:

SELECT qryInAccess.Week, Avg(qryInAccess.Efficiency) AS AvgOfEfficiency
FROM qryInAccess
GROUP BY qryInAccess.Week;
 
The query for that should look like

SELECT [Week], Avg(Efficiency) as AvgEfficieny
FROM YourTable
GROUP BY [Week]
 
Back
Top