Crosstab query report

[Beth]

Hello,
I have a report based on a crosstab query where the data is a test score by
test date. I want to have code that runs on open for the report to set the
date fields, but I don't know how to make that happen.

The problem is that I have code running to dynamically populate the dates in
the crosstab query. That code also creates a text box that looks like
(02/01/06 02/28/06 03/04/06.....) that I use as the labels for my
date columns. Those parts work. When I try to set the data field (Date1)
equal to the first date, 02/01/06, it doesn't recognize it. I did that by
setting the Date1.controlsource = 02/01/06.


Ex:

Student Total points Date1 Date 2 Date 3
Date 4
Jane Doe 500 90 90 200
120
John Doe 400 100 100
200

Can someone please explain how to make the date fields populate on report
open?
Thank you so much!
Beth

 

[Duane Hookom]

Are your date intervals arbitrary or can they be a specific interval like 7
days or 3 weeks or 1 month?

 

[Beth]

They are arbitrary. I have a table, tblTests, where the user defines the
dates for the tests they are giving, so they can make the date set anything
they want.
Thanks,
Beth

 

[Duane Hookom]

I would then use the Crosstab.mdb sample found at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. It would be much less
code and you wouldn't need any code in your report.