Query - Attendance (Dates Top, Month Left)

[zodiaceuk]

Hi All,

I'm looking to adjust a query to display days along the top and month down the left column, is this possible please?

Tables:
Table1 = Months (January-December) & ref (numbers 1-12)
Table2 = DayNum (day numbers 1-31)
Table3 = Data: Date, code

I'd like any code to show the output table in the corresponding day/month, like below.
Black fields to be left empty
(if possible colour missing month days black i.e. 29th-31st Feb, 31st April etc)

I'd like to be able to apply colours to the data as well.
Sick = Red, Late = Yellow etc,
if there is more than one entry for the same day (i.e. late then half day AL etc) another colour is shown?

Is this at all possible please?
thanks in advance for any help

	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31
January					Sick
February
March															Annual Leave
April
May
June																								Late
July
August										Late, Half Day AL
September
October
November
December

<tbody>
</tbody>