Simple Average

[simon4amiee]

24/09/12 Team 1 = 90%
21/09/12 Team 1 = 85%
24/10/12 Team 1 = 93%
25/10/12 Team 1 = 70%
24/09/12 Team 2 = 50%
22/09/12 Team 2 = 68%
25/10/12 Team 2 = 91%
28/10/12 Team 2 = 99%

3 fields Date, Team, Average.

How do i get the average per month of each team please

 

[bob fitz]

If you have a field called date you should change it to something more meaningful. Date is a "reserved" word and will cause you problems. See: http://allenbrowne.com/AppIssueBadWord.html#Top

Can you tell us the name of your table.

What is the Data Type of the field called "Average".