RE: A query that groups information by month

2004-06-10 Thread shaun thornburgh
5 4 5 7 125 1 Project 3 8 7 1 9 2141 Thanks for your help From: "Sunmaia" <[EMAIL PROTECTED]> To: "shaun thornburgh" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]> Subject: RE: A query that groups information by

RE: A query that groups information by month

2004-06-10 Thread Sunmaia
select month(booking_date) bookings_month, count(bookings) as bookings GROUP BY month(booking_date) Peter > -Original Message- > From: shaun thornburgh [mailto:[EMAIL PROTECTED] > Sent: 10 June 2004 11:12 > To: [EMAIL PROTECTED] > Subject: A query that groups infor

A query that groups information by month

2004-06-10 Thread shaun thornburgh
Hi, I have a table that holds information on bookings for a scheduling system. Is it possible to produce a report that lists total bookings data by month with one query i.e. Jan Feb Mar Apr May Jun Jul 6 7 3 9 2 4 3 Thanks for you help _