I have a table "tblBooking" with the following fields Booking ID, Table ID, Staff ID, Date Booking Taken, Date Booking For, Time Booking For, Number Of Seats, Customer ID.
I need to create two queries which will allow me to create two graphs.
- I need to make a graph that will group all bookings by the hour and then count how many bookings are in that time range to create a graph. e.g. count number of bookings between 7-8, 8-9, 9-10, 10-11, 12,13 etc. and allow to create graph
- The second query is similar to above but instead of the time and group by hour I wanted to work out the busiest month
Any help would be great
THANKS
STUART
stupiemountain@msn.com