Average of multiple records based on similar date

Access newbie here, I am trying to figure out how to set up a query
that will return an average from multiple records all created on the
same date. Table has the following fields date, weight1, weight2. There
are 30-40 records per day and I would like to be able to have the query
find like dates (without having to enter a date) and give me an average
for all of the weight1 and weight2 records. Is this possible? Thanks!

re: Average of multiple records based on similar date

Restructure your database before you get any more data like this.
Normalization 101. Then you can use pure SQL.

tblMeasurement(
PersonID,
TimeStamp (date/time field),
Weight)

THen you can do AVG and all those other fun things.