[AccessD] Strange reports

Susan--

I found good info on programmatically creating and populating Excel
workbooks and sheets by joining "Smart Access" at www.pinnaclepublishing.com
for a while.  Luckily, I haven't had a big need to code anything for Excel
that is this complicated (... yet *greatful laugh*)

For Access 2000 ... a Set objXL3 = CreateObject("Excel.Application.8") will
get you on your way.

Short of giving you code here ... offlist?

Dave

"It's a thankless job, but I've got a lot of Karma to burn off."

Message: 5
Date: Thu, 24 Apr 2003 09:49:11 -0400
From: "Klos, Susan" <Susan.Klos at fldoe.org>
Subject: [AccessD] Setting up a strange report
To: "'accessd at databaseadvisors.com'" <accessd at databaseadvisors.com>
Message-ID:
	<8213C1F49875D61195DA0002A5412A0301406E6C at mail.doe.state.fl.us>
Content-Type: text/plain; charset="iso-8859-1"

I have a report that I have to create which needs to look like a previous
excel spreadsheet that was created by hand before implementation of the
database.  I want to include several subreports in the detail section but I
cannot get the  headers of the subreports to show up.  I have the main
report bound to the client query which fills in the header information.  I
need to have the following subreports each of which has to have a header and
footer: lodging, food services, facility use, and miscellaneous.  I cannot
do a grouped report from one large query since I need to list all lodging
and food services possibilities whether or not they were used for any one
event and the outer joins won't work.  Any help would be greatly
appreciated.