Need Report To Display MonthDates
Hi,I am working on studentsDatabase... and i store students Checkin Details in Checkin table... which is basically a timestamp which shows students Checkin time in INSTITUTE..i.e the date and time when student comes...Now i have something like this in my Checkin table:
SID: Checkin: StatusCode:
1 02-02-2009 Present
1 03-02-2009 Present
1 04-02-2009 Absent
1 05-02-2009 Present
1 06-02-2009 HomeWork
1 09-02-2009 Present
2 02-02-2009 Present
2 03-02-2009 Absent
2 04-02-2009 Present
2 05-02-2009 Homework
2 06-02-2009 Present
2 09-02-2009 Present and so on....
also i have StudentsDetails table which stores details...
Now i need a report which display:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 and so on till month end
P A H P P P P P P P P P P A
and on top of report i can display labels: where
P: Present; A: Absent; H:Homework..and so on..
Pls help me with this...