Crosstab Query behind Report

[Guest]

Can anyone please help with this problem? I have a report based on a
crosstab query where columns are years going 9 years into the past including
the current one. i.e.. 1997, 1998, 1999, etc. The fields on the report that
are bound to the data appear to be "hard-coded" and need changing at the end
of every year. I have written code to load the labels, etc. with current
info, but is there a way to make the report's text boxes be bound to current
data as well?

Thanks in advance

 

[Roger Carlson]

Reports based on crosstab queries are problematic by their nature. You will
have to program around the problem. On my website:
(www.rogersaccesslibrary.com) there is a small sample database called:
"CrosstabReport.mdb" which shows you how.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Thanks a million, Roger. I've downloaded the sample and it's looking good.
Looks like you have some other good on your site as well.

Thanks again,
Glenn