1. We require an export of Access crosstab query to Excel, then create an Excel chart from the data.
See the attached test Access file - the user will use frmReport to generate the report.
There is a sample output: [url removed, login to view]
2. The crosstab query needs to be modified so that the months are in date order from left to right
3. The solutuion must be generic for any crosstab query. If you need to attach parameters to specific queries, then implement this in the table zstblReport, by adding columns as necessary.
Note: the number of columns will change depending on the date range the user has selected
4. Must be done using Access/Excel/Office 2003
See attached files