Problems with Average

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all!

I have a table that contains data from one month, several rows for each day.
Like this:
2004-05-01 5
2004-05-01 7
2004-05-01 2
2004-05-01 2
....
2004-05-02 4
2004-05-02 6
2004-05-02 17
....
2004-05-03 1
2004-05-03 0
2004-05-03 2

and so on.......

I need to get average values for each day, is this possible and how??

Thanks in advance.
 
Paste this into a query: (New Query, View, SQL View)

Select DateField, AVG(NumberField)
From TableName
Group By DateField


Chris Nebinger
 
You should try making a summary query. You'll only need two
fields/columns. Set the date field to "Group by" and set the score field to
"Avg". You now have the average score for each date.
-Ed
 
Back
Top