robjones23
Registered User.
- Local time
- Today, 13:21
- Joined
- Dec 16, 2004
- Messages
- 66
Hi there,
I've got several queries which create pivot charts displaying various data. Currently, I've got a form with buttons which when clicked display the pivot chart view of the query so that it can be printed off etc...
What I now want to do is to get Access to create a report which contains each pivot chart from each query. This way, we can run ad-hoc reports when required by pressing the individual query pivotchart view buttons and run a report, say monthly, which then takes all these pivotcharts and places them into one single report.
this might not even be possible but thought I'd ask here!!
(PS I've been using MS Access since monday and have never written SQL prior to yesterday so please be patient with me
)
I've got several queries which create pivot charts displaying various data. Currently, I've got a form with buttons which when clicked display the pivot chart view of the query so that it can be printed off etc...
What I now want to do is to get Access to create a report which contains each pivot chart from each query. This way, we can run ad-hoc reports when required by pressing the individual query pivotchart view buttons and run a report, say monthly, which then takes all these pivotcharts and places them into one single report.
this might not even be possible but thought I'd ask here!!
(PS I've been using MS Access since monday and have never written SQL prior to yesterday so please be patient with me