Re: Getting averages in between dates
I assume that your hourly intervals have a date associated with them.
Originally posted by cobs
I have a little problem. I have a table which contains hourly rain levels for 365 days for 5 years....
Is it possible to get a query to get the daily average rain level for just one year???
You could use a totals query and group by the day. Use the suggestion of mjweyland and restrict the dates to what you want. Sum the values by date and then compute an average. You can most easily do this with 2 queries by computing the Sum grouped by the date in the first query and then do the average in the next query.
One SQL statement could also do this but my brain doesn't think that fast and lunch is over.
Hope this helps.
DAO, ADO, SQL, Automation and anything else I can pick up.