Help With Grouping By Hour

[amyjh38]

I'm not sure if this would be better done in a query or report so I am going to start in the query forum. I have a table with 3 fields. TimeStamp, StationID, MeanWind. Ex: 7/1/2014 10:00 PM|WT01|1.2

The MeanWind data is recorded every 10 minutes. So the entry below the above example will be 10:10 PM, etc. Unless there is no MeanWind recorded at 10:10. In that case the next entry would be whatever time there was a MeanWind. (I hope this makes sense)

I need to group the data by each hour with an average wind speed. So I need data from 10:00 PM thru 10:50 PM, then from 11:00 PM to 11:50 PM, etc.

To be honest, I'm kinda lost trying to figure this out. Any and all help will be truly appreciated!

[pbaldy]

Try using the DateValue() and Hour() functions in your query.

[amyjh38]

When I tried that the problem I had is it pulled records from 10:00 PM thru 11:00 PM, then 11:10 PM thru 12:10 PM, etc. I don't know how to specify the group period so it will go from 10:00 PM thru 10:50 PM, 11:00 PM thru 11:50 PM, etc.

I'm not exactly an Access whiz so I'm sure the problem is me!

[pbaldy]

The Hour() function shouldn't have done that. Try this query (I'm assuming you also want to group on StationID):

SELECT DateValue(TimeStamp) AS ReadingDate, Hour(TimeStamp) AS ReadingHour, StationID, Avg(MeanWind) AS WindAvg
FROM TableName
GROUP BY DateValue(TimeStamp), Hour(TimeStamp), StationID