Access Table to Excel Pivot Chart??? 1

[jsaliers]

I have an access database, and a query that makes a table for the user based on a date range. I would like to have something in the database that will put the access table into excel and create a specific Pivot Chart. Is there any way to do this?

I thought about possibly exporting the table to and Excel spreadsheet, and having a macro auto open it, paste it into a template, which would create the pivot chart, but I would like it all automated, so the user can enter the date range, and up pops the chart. What would be the best way to do this?

Thanks in advance!!

Jon Saliers

 

[dawnd3]

Have you considered doing a crosstab query in Access?

Dawn

http://www.calliopeconsulting.net

 

[PepeLeMokko]

If you are using Access 2000 click Forms under Obkects in the Database window toolbar
Click the New button on the Database window toolbar.
In the New Form dialog box, click PivotTable Wizard, and then click OK.
Follow the instructions in the wizard.
There is also a chart wizard

 

[combo]

If you need a pivotchart in excel - just start pivot table wizard and in the first step select external data (upper option - data source) and pivot chart (lower - table or chart).

combo