Crosstab report

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
 
K

Ken Sheridan

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
Crosstab query - MS Access 2000 2
cannot use the crosstab of a non-fixed column as a subquery 3
Basing Report on Crosstab 3
dynamic columns number in crosstab report 4
problem with crosstab query 1
Crosstab Date Range in Reports 3

Top