Hi,
I'm new to MS Access and currently using the 2003 version.
I have had very little VBA coding experience and need to set up a database which will enable to track staffing needs as projects come on and off line.
In the form I have a PivotChart to show one of my select queries, under this I would like a data table which shows the series data (as in Excel).
It would be great if someone could tell me the best way to do this and if it has to be done using code.
Also with the legend it only shows what has been filtered in the series fields not the filter fields. Is it possible to show exactly what has been filtered when the chart is printed?
I thank everyone for there time reading this post in advance.
Any advice would be greatly appreciated.
Cheers
Tony
I'm new to MS Access and currently using the 2003 version.
I have had very little VBA coding experience and need to set up a database which will enable to track staffing needs as projects come on and off line.
In the form I have a PivotChart to show one of my select queries, under this I would like a data table which shows the series data (as in Excel).
It would be great if someone could tell me the best way to do this and if it has to be done using code.
Also with the legend it only shows what has been filtered in the series fields not the filter fields. Is it possible to show exactly what has been filtered when the chart is printed?
I thank everyone for there time reading this post in advance.
Any advice would be greatly appreciated.
Cheers
Tony