Date/Hour Sum Query

  • Thread starter Thread starter Ed Durden
  • Start date Start date
E

Ed Durden

I have a list of dates and times (one field) that I want
to sum by the hour and by the day in two different
queries. Can someone give me an example of the
expressions or queries?

Thanks.

Ed Durden
 
Steve,

Thanks for your help.

I have over 4000 records collected over a two week period
that I want to group together so I can create a chart. I
want to sum the data by hour and by day. Here is an
example of my data:
9/9/2003 22:18
9/9/2003 22:20
9/9/2003 22:26
9/9/2003 22:30
9/9/2003 22:30
9/9/2003 22:31
9/9/2003 22:53
9/9/2003 23:02
9/9/2003 23:19
9/9/2003 23:51
9/10/2003 0:07
9/10/2003 0:58
9/10/2003 1:34
9/10/2003 2:37
9/10/2003 6:32
9/10/2003 6:32
9/10/2003 6:32
9/10/2003 7:33
9/10/2003 8:43
9/10/2003 8:44
9/10/2003 8:52
9/10/2003 8:52
9/10/2003 8:53
9/10/2003 8:54
9/10/2003 9:02
9/10/2003 9:30

Ed Durden
 
So, what do you envision 'Summing by Hour' to be?

A count of the records received during the hour, or the Sum of the time for
each day? Is 22:18 22 minutes, 18 seconds, or 10:18pm?

You need to be VERY specific from here on.
 
Back
Top