How to print data on a timeline format

[ctkmak]

I have a table to store our student sick leave records, we would like to print its on a timeline report. I have already sort the db by student name but I don't know how to print it in a single timeline.


Student Record:

StudentA 1/10/2005
StudentA 5/10/2005
StudentB 20/10/2005
:
:

Required Timeline Report:
2 3
Date 1 2 3 4 5 .................... 0...........1
Student A X X
Student B X

 

[namliam]

Try creating a "crosstab query" this can do, what you want...

Good Luck