[AccessD] Creating a Spreadsheet from a Report

Rocky - I have to ask:

Why does she want a spreadsheet to look like a report?  What's she going to
do with it?

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Wednesday, September 15, 2010 4:10 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Creating a Spreadsheet from a Report

Dear List:

I have a client who wants one of the reports in my app to be exported as a
spreadsheet.  But nota flat file.  She wants the spreadsheet to look like
the report - header line, details with their own fields headings, plus two
other sub reports.  

I've done this with other reports on a cell by cell basis where the Transfer
method won't work.  Big PITA.  Is there an easier way to do this?

 

MTIA

Rocky