Time Averaging Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a huge excel file that contains 15 min. time periods with
corresponding data. I would like to use Access to convert the data from 15
min. increments to daily average data. I've imported the data, but I can't
seem to figure out the queries necessary for the conversion. Any suggestions?
 
Use the following --
SELECT CDate(Int([YourDateField])) AS Dates, Avg([YourTable-1].num) AS Average
FROM [YourTable-1]
GROUP BY CDate(Int([YourDateField]));

The INT removes time from the date-times.
 
Back
Top