Hi Everyone,
I am looking for a query to generate the daily, hourly and monthly average. I have a table with columns Date, Time (hh:mm:ss), Pressure and temp. in the Time column I have data for every seconds for some days and every 30 second data for some days. I want to generate a query which can give me the records for hourly average, daily average and monthly average.
I would be very thankful if someone could help me to generate this query in Ms Access.
Thanks in advance for your help.
Best Regards
Tahir
I am looking for a query to generate the daily, hourly and monthly average. I have a table with columns Date, Time (hh:mm:ss), Pressure and temp. in the Time column I have data for every seconds for some days and every 30 second data for some days. I want to generate a query which can give me the records for hourly average, daily average and monthly average.
I would be very thankful if someone could help me to generate this query in Ms Access.
Thanks in advance for your help.
Best Regards
Tahir