print pivot table data as report

[Grey]

I have used pivot table function in MS Access to design a report. HOW can I
print the pivot table data in a report format as I use print function in
pivot table, it only dump the screen ???


million thanks

 

[[MVP] S.Clark]

The short answer is you can't.

Reports are based on tables or queries, but a pivot table is a special kind
of query. You may be able to export to Excel or something similar.

A pivot table is like a Crosstab query on Steriods. If you find that you
have settled on a particular layout for the report, then you can create a
crosstab query with the similar layout, and use that as the basiss for the
report.