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

 

[JerryDennison]

I have often found it far easier to work with Access data from Excel rather than try to control Excel from Access. You can use any query created and saved in Access or one you develop yourself from wihtin Excel as an external data source for Excel. You can also control what data is returned through the query from Excel by applying filters. Once the data is linked to Excel it can be refreshed on demand with the "click of a button". This will give you "live" data for your analysis.

 

[Quehay]

Why not create another query that looks at form values (if you just want current record or the group displayed in the form) for the desired fields. Put a hyperlink to the query on the form, click it, and drop the recordset into Excel?
Or just reformat once you're in Excel (which Jerry suggested).