Average Multiple Scores for Day

[Wapug]

I am trying to create a query that looks at a table to find the average score for each day. I need to query the table and find the Distinct dates, these could be multiple records with the same date but different scores, and then average the score and end up with my Date & average score for the day. For example:

ID DATE SCORE
3 8/1/18 95.60
7 8/2/18 93.95
9 8/1/18 86.32
13 8/1/18 75.90

RESULT:
DATE SCORE
8/1/18 85.94
8/2/18 93.95

 

[Wapug]

Sorry I wanted to post my example a bit different

DATE SCORE
8/1/18 95.60
8/2/18 93.95
8/1/18 86.32
8/1/18 75.90

RESULT:
DATE SCORE
8/1/18 85.94
8/2/18 93.95

 

[Gasman]

Just group by date and AVG() the score.
I used my Emails table to test.

HTH

SELECT Emails.TransactionDate, Avg(Emails.Score) AS AvgOfScore
FROM Emails
GROUP BY Emails.TransactionDate

 

[plog]

That's a simple aggregate query using the AVG function:

https://www.w3schools.com/sql/sql_count_avg_sum.asp