S
Sareny
I am trying to create a report based off my cross tab query. I
dynamically assigned the fields on the report and used VBA to load the
appropriate data into the field.
My issue involves where there are too many columns to fit on one
page. I have a page footer (confidential info and the page number).
The Report footer has fields that summarize the columns.
I would like to have the columns that do not fit on the one page to be
put on a separate page with the main column (first name) repeated
(like Excel). It would be nice if the page footer appears on this
page also.
I have looked through all the postings that I could find and I cannot
find a reasonable Access solution. Is there a way to force a page
using VBA that would still account for the data already listed from
the crosstab query? Or is there a way to use a Macro and VBA to
create an Excel Spreadsheet with a Pivot table based on my Crosstab
Query (with all the formatting you can do in Excel)? I can do it from
Excel, but I don't know how to do it from Access and put it into
Excel.
I know some coding, but not a lot.
The information in the crosstab query is updated by a set of managers
who then create the report. So I'd want the report to be something
that would be user friendly that can be run from Access.
If it
was just me, I wouldn't be worried about the page footers, etc.
Thank you.
dynamically assigned the fields on the report and used VBA to load the
appropriate data into the field.
My issue involves where there are too many columns to fit on one
page. I have a page footer (confidential info and the page number).
The Report footer has fields that summarize the columns.
I would like to have the columns that do not fit on the one page to be
put on a separate page with the main column (first name) repeated
(like Excel). It would be nice if the page footer appears on this
page also.
I have looked through all the postings that I could find and I cannot
find a reasonable Access solution. Is there a way to force a page
using VBA that would still account for the data already listed from
the crosstab query? Or is there a way to use a Macro and VBA to
create an Excel Spreadsheet with a Pivot table based on my Crosstab
Query (with all the formatting you can do in Excel)? I can do it from
Excel, but I don't know how to do it from Access and put it into
Excel.
I know some coding, but not a lot.
The information in the crosstab query is updated by a set of managers
who then create the report. So I'd want the report to be something
that would be user friendly that can be run from Access.
If itwas just me, I wouldn't be worried about the page footers, etc.
Thank you.