Hi guys
I am using Access 2007 and have an application that already has a number of Pivot Charts that are all working correctly.
I tried to created another Pivot chart on top of a simple query and have the following problem:
I have a table that has individual records in it for each item in an invoice. each each record has a field called "Invoice Date".
I want to count the number of invoices each month and display them in a Pivot chart.
I create the query without any issues, I then flick into Pivot Chart view and drag and drop the fields onto the chart and it looks fine.
The problem I have is that when I save the Pivot Chart and then reopen the query, the chart is displayed without any of the fields!
I have spent hours and hours trying to figure this out and it's driving me nuts as I am sure that it is something simple that I am forgetting.
Any help is very much appreciated.
Cheers
Greg
I am using Access 2007 and have an application that already has a number of Pivot Charts that are all working correctly.
I tried to created another Pivot chart on top of a simple query and have the following problem:
I have a table that has individual records in it for each item in an invoice. each each record has a field called "Invoice Date".
I want to count the number of invoices each month and display them in a Pivot chart.
I create the query without any issues, I then flick into Pivot Chart view and drag and drop the fields onto the chart and it looks fine.
The problem I have is that when I save the Pivot Chart and then reopen the query, the chart is displayed without any of the fields!
I have spent hours and hours trying to figure this out and it's driving me nuts as I am sure that it is something simple that I am forgetting.
Any help is very much appreciated.
Cheers
Greg
