<html><div style='background-color:'><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*.</html>