infomania
Programmer
- Oct 27, 2002
- 148
I am using Access 2003 (as Access 2000) to develop a crosstab report that should look lile the following:
DIAMETERS
WIDTH 127 135 137 147
205 25
215 15 5 12
300 1 3 14
As the data set grows, the number if diameters may increase and it is unknown what the exact value of the diameter will be. I would like to create a report that is dynamic in the sense that if there are more or less diameters due to record selection criteria, the report automatically adjusts. The query is dynamic but the number and values of report column headers, using the query, seems to be fixed base on the data set at design time. Is there any way to get the Access report to act dynamically?
WIDTH 127 135 137 147 157
205 25
215 15 5 12 6
300 1 3 14
DIAMETERS
WIDTH 127 135 137 147
205 25
215 15 5 12
300 1 3 14
As the data set grows, the number if diameters may increase and it is unknown what the exact value of the diameter will be. I would like to create a report that is dynamic in the sense that if there are more or less diameters due to record selection criteria, the report automatically adjusts. The query is dynamic but the number and values of report column headers, using the query, seems to be fixed base on the data set at design time. Is there any way to get the Access report to act dynamically?
WIDTH 127 135 137 147 157
205 25
215 15 5 12 6
300 1 3 14
