transform (sort of)

J

J. Freed

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).
 
Top