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!

Grouping in line graph by 2 hr period.

Status
Not open for further replies.

PROXI

Vendor
Sep 16, 2003
136
US
I am trying to take a range of data (about 1200 records) that is put into a query. the query just has 1 field in it (Time). I want to have a line graph show the number of instances in 2 hr groupings. Right now this is the statement that is used in the rowsource
==============================================

SELECT (Format([Time],"TTTTT HAMPM")),Count(*) AS [Count] FROM [LoanTime] GROUP BY (Int([Time]*24)),(Format([Time],"TTTTT HAMPM"));

==============================================


I have tried to change the 24 in the above line and it did nothing for me. How can I get this to work. I am just staring using this part of the reports and don't really understand enough to do it. Any help will be appreciated.




Thanks,

PROXI
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top