HI,
I am having a weatehr data in which the temperature and othe parameters were recorded ar every 15 minutes interval but i wnat the average temp at every on hr(60 minutes).
My data is ln this form
Time temperature humidity
0 20 6
15 22 2
30 15 4
45 26 10
60 30 11
75 15 8
i would be thanlsful toa nyone who can help me in writing a query in access.
Thanks
I am having a weatehr data in which the temperature and othe parameters were recorded ar every 15 minutes interval but i wnat the average temp at every on hr(60 minutes).
My data is ln this form
Time temperature humidity
0 20 6
15 22 2
30 15 4
45 26 10
60 30 11
75 15 8
i would be thanlsful toa nyone who can help me in writing a query in access.
Thanks