Hiya folks!

Can anyone explain how to create an Access report from a PivotTable form?

And what about a PivotTable form that can be formatted (text, colours, etc.)

Thank you!

Well, I know that a report must be based off some datasource, whether it is a table or query, so you'll have to place a table between the pivottable form and the report.

As far as formatting the pivottable form, it seemed quite easy to me, just open the form in design view, and format to your heart's content!

Hope this helps,

Shane

Thanks for your reply!

I had created the form using a table that includes all the data. The problem with the pivotable form is I cant seem to format it. When I open the pivotable form in design view, it only shows the form in a "columnar" format. Regardless of how I format the objects, it remains in the Access default format for pivottables when I go back to Form view.

Thank you!