transform (sort of)

[Guest]

I'm trying to create an Excel export for a report/subreport combination. The
subreport contains data organized horizontally; i.e.

acctcode1 balance1 acctcode2 balance2 etc....

The original data is

acctcode balance (fields)
acctcode1 balance1
acctcode2 balance2 etc. (data)

The export takes the subreport data and lists it below the rest of the
associated record. The sub-records need to be transposed to make this work,
and the report looks perfect, but Access doesn't export it the same way. Any
ideas?

TIA. (remember, only 20 shopping days till Christmas/Hanukah).

 

[Gman]

How are you exporting to Excel? A few suggestions:

- If you're using VBA to control Excel you can use application.transform.

- If you're passing an array around within Access you could transpose
yourself in a custom function.

- Just write to Excel line by line... reading down the recordset.