Turning a Pivot Table into a Report

K

Kelvin Wilson

G'day!

Hoping for some help from a human (or two). I've been able to get this
far from the Help system, but now I'm stumped.

I want to produce a written report to show the changes made to contact
details in a CRM application.

As users modify details, the changes are trapped and appended to a
table (tblMod) which records the date (ModDate), the name of the field
changed (ModField), the new datum in the field (ModString) and the
identifier of the Contact (ContactID).

So, tblMod has these fields:
ModID (Autonumber)
ModDate
ModField
ModString
ContactID

I want to print a report based on a pivot table that will have
the data in ModField as the column headings,
the ContactID as the row headings, and
the Data in ModString as the value.

I can make the Pivot Table.

How do I make a Report from a Pivot Table?

Or do I have to start again from a different angle?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tuening Pivot Table into Report 0
Pivot table report invalid 0
Change report firlds in pivot tables and charts with one selection 0
How to create report from Pivot Table View of Union Query? 3
Connection files and pivot tables 0
Top Costs Per Product Per Time Period Pivot Table 0
relationships/ tables 4
Using VBA on Excel Pivot Tables 3

Top