Between Dates and then want Average of results

  • Thread starter Thread starter tshay
  • Start date Start date
T

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.
:confused:
 
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
 
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:]
 
Back
Top