Tobi,
My sample db named
MotelBooking might be of interest to you. It is available
at Rogers Access Library (other developers library). Link -
http://www.rogersaccesslibrary.com
Command button captioned "Booking Status (Style 2) -
Dates Across Columns" on the main switchboard might be relevant to your
situation.
You could adapt the underlying approach suitably, for
your specific needs.
Best wishes,
A.D.Tejpal
----- Original Message -----
Sent: Wednesday, January 11, 2006
21:26
Subject: [AccessDevelopers] Crosstab
column headers
I am developing a report on test scores of a test
which can be given multiple times, and at this point, I have a crosstab query
that uses the test date as the header. I would like to have a number
instead of the date in the header, so that the first test header is "1", and
then they count up in the order they were given. I plan to show the
dates separately, probably as a sub-report. Any clues to how to do
this?
The SQL currently looks like this:
TRANSFORM First(qryrptRawScores.Q_Answer) AS
FirstOfQ_Answer
SELECT
qryrptRawScoresYouthID, qryrptRawScores.Q_Order
FROM qryrptRawScores
WHERE
(((qryrptRawScore.YouthID)= xxxx ))
' value to be filled in
GROUP BY qryrptRawScores.YouthID,
qryrptRawScores.Q_Order
ORDER BY
Format([TestDate],"Short Date") DESC ' "DES" is counterintuitive, but
works the way I need it!
PIVOT
Format([TestDate],"Short Date");
=======
TIA
Tobi Hoffman
Dept. of Youth Services
Boston, MA
