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