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
 
Top