Attendance Report that Shows additional dates as they are added

Access 2003

I am trying to figure out how to develop a report that will display
students in 1st column, dates across the top, and "P" or "A" for the
data. I have a crosstab that displays what I want. I can create a
report that shows the data from the crosstab that looks like what I
want, However, these are "static controls" so when I add a class then
I would need to edit the report.

I need the report to show additional classes (dates) as they are added
to the database.

The final report should display simalar to an Excel spread***.

Ex:
1/21 1/22 1/23
John Doe P A P
Jane Doe P P A

In the "Ex" if I added data for "1/24" then I need it to show in the
report without having to edit the report.

I hope I have explained what I am trying to accomplish here, it's late
and I'm braindead tonight.

Thanks
Dale
.