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
==============================================
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