Between Dates and then want Average of results

[tshay]

I am using a query to access data in a table. I am using in the date
field: criteria for data I am using: Between [Type the beginning date:]
And [Type the ending date:]. This gives me all the records between
those dates, which is OK. But I am looking for the average of all the
records between those dates. Thank you for any help/hints on this.

 

[Steve Schapel]

Confused,

Make your query into a Totals Query (select Totals from the View menu
in design view od the query), and then enter Avg in the Totals row of
the query grid.

- Steve Schapel, Microsoft Access MVP

 

[John Spencer (MVP)]

If you are using the query grid, then make a totals query and select WHERE under
the Data column instead of GROUP By. An SQL statement would look something like:

SELECT Avg(SomeField)
FROM YourTable
WHERE SomeDate Between [Type the beginning date:]
And [Type the ending date:]