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 information by month
Hi,
Hi,
Thanks for your reply Peter. Each booking is based on a particular project
by Project_ID. Is it possible to modify the query such that the projects are
listed in turn? For example:
Jan Feb Mar Apr May Jun Jul
Project 1 6 7 3 0 3 4 3
Project 2