Crosstab report

  • Thread starter Thread starter davethewelder
  • Start date Start date
D

davethewelder

Hi, is it possible to export to excel a crosstab report in order the
resultant file is in the crosstab format e.g with row and column headings
intact.
This would make my task so much easier.

Davie
 
Cut out the middleman and export the crosstab query on which the report is
based using code along these lines:

DoCmd.TransferSpreadsheet _
TransferType:=acExport, _
Tablename:="YourQuery", _
Filename:="F:\SomeFolder\SomeSubfolder\SomeWorkbook.xls"

Ken Sheridan
Stafford, England
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab Loosing shape 1
Is it possible to get Access to ignore not recognizing a field nameusing some sort of error handling 1
dynamic columns number in crosstab report 4
Crosstab query - MS Access 2000 2
cannot use the crosstab of a non-fixed column as a subquery 3
problem with crosstab query 1
Basing Report on Crosstab 3
Crosstab Date Range in Reports 3

Back
Top