Crosstab Query to Excel...

[dodgyone]

I have created a crosstab query and from this I have created a form.

How can I send the data displayed to Excel so that only certain fields (which I specify) are transferred from the form (I have tried the regular analyze with Excel feature but this isn't really an ideal solution). I have already created an Excel file which has a chart in it to display the data received. Can I transfer the Access data into the already created Excel file and then select where the information is placed on the worksheet (so that Excel uses the information for the chart)?

Any ideas would be welcomed... thank you

Marcus

 

[Katerine]

Hi dodgyone,
The easiest way to do this (if you don't mind doing it manually), is to select the records in the select query result set, copy, and paste to Excel.

Or, if you don't like that solution, you could code it in Excel..