Conversion in Access table

[Lucas83]

Hi everyone,

I'm new here and I'm a beginner with Access. I hope anyone can help me, because I'm a little short of time. I have a table in Access. The data in this table is about a weather station. I have a few columns, first colum is date and the format is like this: 17/02/2009 0:31:00. Second column is temperature, third column is precipitation, and so on. The data is registred every minute therefore I have as rows as minutes has a day:

17/02/2009 0:31:00
17/02/2009 0:32:00
17/02/2009 0:33:00
...

What I need is to convert data from minutes to hour, I mean, to get 60 rows (since an hour has 60 minutes) and get the mean for temperature and mean for precipitation for those 60 rows. I was thinking about using a counter to get 60 rows and calculate what I need but I still don't know how to carry it out in Access. I would be very grateful if anyone could help me, giving me any clue to get what I need. Thanks in advance!!

 

[GaryPanic]

thats a lot of data
given 24 hours and 60 minutes =1440
in a year 525600 rows...


what you are asking is out of my league - but is it realistic - most weather stats are hourly /daily (Weatherbase being one)

 

[ajetrumpet]

gary is absolutely right. your database will become too large to operate in a short time.

using a form to get these averages, you're gonna need parameters in the DATE FIELD. you're going to need a date parameter, an hour param, and a minute param if needed.

then you use a recordset object to open the table and find the record that 60 records past the lower bound criteria that is inputted in the query.