Hi all I have a database table which stores data for completed personal training sessions during completed shifts at a gym.
What I have been asked to do is to provide management with a report showing a break down of the number of training sessions per hour during a given shift. I have been able to extract the records for each shift. Whta I am now trying to do is workout the best way to display the data. I have a column in the table which contains the date and a start-time i.e. 2008-05-18 07:31:49 - I think the best will be to display a breakdown of the jobs by hour i.e. all jobs started between 7am to 8am, 8am to 9am etc Thanks in advance Also thinking about using a graph if possible as well. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305577 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
