Query help

  • Thread starter Thread starter jpBless
  • Start date Start date
J

jpBless

TimeEntered
Amt

55.44
6.25am

60.99
6.26am

77.99
6.20am

40.99
7.10am

100.20
7.50am

100.50
8.00am

120.35
8.25am

100.00
8.56am

120.25
8.59am

100.55
10.00am

20.22
10.41am




I have a table as above... I would like to make a query to return records as
below (SQL Query to return 2 fields (time range and total))... I will
appreciate help/pointers



TimeEntered Amt

6am-7.59AM 335.61

8am-9.59AM 441.11

10Am-11.59 120.77
 
Lost some formating in my post... apologozie... More like

TimeEntered Amount

55.44 6.20am

60.99 6.25am

70.99 6.26AM

40.99 7.10AM

100.20 7.50AM

100.50 8.00AM

120.35 8.25AM

100.00 8.56AM

120.25 8.59AM

100.55 10.00AM

20.22 10.41AM



SQL Query to return 2 fields (time range and total)

TimeEntered Amt

6am-7.59AM 335.61

8am-9.59AM 441.11

10Am-11.59 120.77
 
Actually the time was stored as long date... like 1/2/2009 7:22:38 PM Used
short time just for posting this. Anyway thanks for your input... I am
trying to figure it out. Thanks a lot
 
Back
Top