Count and Average

[kitty77]

How can I count the records for each day (by date) and then get an average for each day? What is the best way?

Thanks...

 

[isladogs]

Use aggregate (totals) query or queries.
First group records by date. Next add the date field again or ID field and change group by to Count.
Depending on what you want to average, do something similar but set to average

 

[plog]

Yes this is a simple aggregate query, using common aggregate functions:

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

SELECT DateField, COUNT(DateField) AS RecordCount, AVG(FieldToAverage) AS AveragedField
FROM YourTableNameHere
GROUP BY DateField