Need Help on AVG Query

[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.

 

[Marshall Barton]

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

SELECT Week, Avg(Efficiency) As TotalEfficiency
FROM yourquery
GROUP BY Week

 

[Duane Hookom]

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;

 

[John Spencer]

The query for that should look like

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

 

[scottyp1967]

Worked like a charm.

Thanks to everyone for your help.