That is definitely possible and the method of display you suggested seems good to me. A graph would be a nice touch. The decision of how best to display the data might rest with the person who has to view it.
-Mike Chabot On Sat, May 17, 2008 at 10:34 PM, Toby King <[EMAIL PROTECTED]> wrote: > 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:305578 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
