<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=215242706-25042003><FONT face=Arial color=#0000ff size=2>Sorry
to jump in, why not add a field in your Union 'querries'. Have that field
describe what the data is. I do that all the time in Union querries, where
I have similar data, and I need to distinguish where it is coming from. I
just add a field like "InterimReport" As ReportType in one part, and
"FinalReport" As ReportType in the second part, etc. Then my recordset has
a groupable field.</FONT></SPAN></DIV>
<DIV><SPAN class=215242706-25042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=215242706-25042003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Klos, Susan
[mailto:Susan.Klos@fldoe.org]<BR><B>Sent:</B> Thursday, April 24, 2003 10:48
AM<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B> RE:
[AccessD] Setting up a strange report<BR><BR></FONT></DIV>
<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 face="Geneva, Arial, Sans-serif" color=#6666ff 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></BLOCKQUOTE></BODY></HTML>