Fixed Report Column Headings from a Crosstab query

[Beth]

Hello,
I have a crosstab query where I have fixed columns that I create by using a
piece of code to pull dates from an events table and use the dates as the
headings. There are always going to be more dates in the events table than
there is data in the queried table. The dates in the events table also
update fairly frequently.
I have a report formatted to include all the dates, but right now I have to
manually change the data source for each of the 25 dates in the report and
the 25 labels that go with them.
Is there a way, like in the crosstab query to run some code and have the
data fields and labels in the report change based on the dates I have in the
events table?
Thanks in advance,
Beth

Ex:
tblEvents tblResults
txtTestDate txtTestDate
txtGrade
Crosstab query on tblResults to create a grid showing all the test dates for
the semester, and populating the grades for tests that have been taken and
scored.

Report

Student 1/15/06 2/15/06 2/21/05 Total
Jim 100 98 198
Judy 75 95 170
George 97 90 187

 

[Duane Hookom]

There are a couple sample crosstab reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. You might want to check
out the Crosstab.MDB.

Am I correct in assuming your dates are not constant intervals like every
weekday or every week?

 

[Beth]

Duane,
I will look at those example. The dates are random.
Thanks,
Beth