how do i group houly data from minute increment in a query in acc.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am working with data set up in 15 minute increments and i need an houly
average of the data. the time is set up in military time. i am trying to do
a group by query, but i do not know the correct way to get it to group by the
hour. i figure you nned something in the criteria, i am just not ure what.
 
Type this into the Field row in query design:
DatePart("h", [Date1])
replacing Date1 with the name of your date field.

That should give you the hour (0 ~ 23), so you can group on that.
 
Back
Top