I am using Access 2000 and Access 2003.
I have a crosstab query. I would like to have a command button on a form that will create a report with the crosstab query as the record source, then add the all the fields to the report. I can not use a static report becasue as each week goes by, the crosstab query will add a new "column".
The fields in the crosstabb query are:
TeamName
AgeGroup
League
GameDate
Points
Points are summed in the crosstab query. I have attached screenshots of the query and a manually created report.
I have a crosstab query. I would like to have a command button on a form that will create a report with the crosstab query as the record source, then add the all the fields to the report. I can not use a static report becasue as each week goes by, the crosstab query will add a new "column".
The fields in the crosstabb query are:
TeamName
AgeGroup
League
GameDate
Points
Points are summed in the crosstab query. I have attached screenshots of the query and a manually created report.
Attachments
-
14.8 KB Views: 67
-
98.7 KB Views: 54