<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<META content="MSHTML 5.00.3502.4856" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff size=2><SPAN class=781030114-24042003>Thanks,
Don. This worked so far. I may have to ask later how to group
them. I had to list them with the same headers (I think) and the only way
to distinguish between the groups is by the number in the ordr field.
Lodging numbers from 1 - 19, Food services from 20 - 39 and Miscellaneous from
40 - 59. </SPAN></FONT></DIV>
<DIV><FONT color=#0000ff size=2><SPAN
class=781030114-24042003></SPAN></FONT><FONT face=Tahoma size=2>-----Original
Message-----<BR><B>From:</B> Don Elliker
[mailto:delliker@hotmail.com]<BR><B>Sent:</B> Thursday, April 24, 2003 9:58
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> Re: [AccessD]
Setting up a strange report<BR><BR></DIV>
<BLOCKQUOTE></FONT>
<DIV>
<DIV>
<P><BR>Perhaps a Union Query would do the trick? Then you can group as you
wish.<BR>_d</P></DIV>
<DIV></DIV><BR><BR><BR>
<DIV></DIV>
<DIV><FONT color=#6666ff face="Geneva, Arial, Sans-serif" size=2><EM>"Things
are only free to the extent that you don't pay for them." </EM></FONT></DIV>
<DIV><FONT color=#33cc66></FONT></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: "Klos, Susan" <SUSAN.KLOS@FLDOE.ORG>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: "'accessd@databaseadvisors.com'"
<ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: [AccessD] Setting up a strange report
<DIV></DIV>>Date: Thu, 24 Apr 2003 09:49:11 -0400
<DIV></DIV>>
<DIV></DIV>>I have a report that I have to create which needs to look like
a previous
<DIV></DIV>>excel spreadsheet that was created by hand before
implementation of the
<DIV></DIV>>database. I want to include several subreports in the detail
section but I
<DIV></DIV>>cannot get the headers of the subreports to show up. I have the
main
<DIV></DIV>>report bound to the client query which fills in the header
information. I
<DIV></DIV>>need to have the following subreports each of which has to have
a header and
<DIV></DIV>>footer: lodging, food services, facility use, and
miscellaneous. I cannot
<DIV></DIV>>do a grouped report from one large query since I need to list
all lodging
<DIV></DIV>>and food services possibilities whether or not they were used
for any one
<DIV></DIV>>event and the outer joins won't work. Any help would be greatly
<DIV></DIV>>appreciated.
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></DIV><BR clear=all>
<HR>
Add photos to your e-mail with <A href="http://g.msn.com/8HMEENUS/2746">MSN
8.</A> Get 2 months FREE*. </BLOCKQUOTE></BODY></HTML>