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!!

[pbaldy]

Try a query like this:

SELECT Format([DateFieldName],"yyyymmdd hh") AS DayHour, Avg(RainField) AS AverageRain
FROM TableName
GROUP BY Format([DateFieldName],"yyyymmdd hh");