Finding averages after every 60 minutes

reddyadi

New member
Local time
Today, 10:51
Joined
Feb 16, 2005
Messages
5
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
 
Not sure what you mean.

At 60 minuits do you want the database to take the 4 most current updates, and average them on a form? or do you want it to put it into another table? or what?

Is the data already in the database? or do you want it to happen every hour while the database is open?

You aren't giving enough information.
 
average after every 60 minutes

Thanks
but this query is giving me the data after every 60 minutes not the average of the the 60 minutes reading, i need the average of temp and humidity at after evry 60 minutes i.e the average of the 4 records at regular intervals.

thanks
 
IS the data in sequence? Does it have a record ID?

What's the access version?

HAve you looked at creating the pivot chart form?
 
reddyadi said:
Thanks
but this query is giving me the data after every 60 minutes not the average of the the 60 minutes reading, i need the average of temp and humidity at after evry 60 minutes i.e the average of the 4 records at regular intervals.

thanks
I think Jon K has provided the correct solution in the Queries forum:
http://www.access-programmers.co.uk/forums/showthread.php?t=81553
 

Users who are viewing this thread

Back
Top Bottom