Formatting query result like a calendar

Hi,

I have a query result that comes out as follows (this is an excerpt, the whole thing shows a whole month):

Date   ID    Day
31/03   1    Mon
01/04   0    Tue
02/04   1    Wed
03/04   1    Thu
04/04   0    Fri
07/04   1    Mon
08/04   0    Tue
09/04   1    Wed
10/04   1    Thu
11/04   0    Fri

I need it in the format:

Date      Mon   Tue   Wed  Thu  Fri
31/03      1     0     1    1    0
07/04      1     0     1    1    0


Any ideas?

Thanks!
Jen





----
Sent using GuerrillMail.com
Block or report abuse: https://www.guerrillamail.com/abuse/?a=UUZnFAFNUKUZqB6742oYYBHUXMbe3cVX