Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sum a total per hour

Status
Not open for further replies.

skiabox

Technical User
Joined
Aug 27, 2002
Messages
125
Location
GR
I have two columns.
The one column has a total field from a table and the other has a time only(not date) field taken from another field of the same table.
I made a sorting by the time field and it begins the sorting after midnight 00:00 and it arrives at 23:59 or something like that(it is a sorting of a day).
Is there any way I can get the totals per hour?
Thank you!
 
Ok.I've done it!
I made a grouping over that sorted time field by hour and then I simply entered a summary in the group footer!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top