Drew Wutka
DWUTKA at marlow.com
Fri Apr 25 01:29:48 CDT 2003
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. Drew -----Original Message----- From: Klos, Susan [mailto:Susan.Klos at fldoe.org] Sent: Thursday, April 24, 2003 10:48 AM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Setting up a strange report 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. -----Original Message----- From: Don Elliker [mailto:delliker at hotmail.com] Sent: Thursday, April 24, 2003 9:58 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Setting up a strange report Perhaps a Union Query would do the trick? Then you can group as you wish. _d "Things are only free to the extent that you don't pay for them." >From: "Klos, Susan" >Reply-To: accessd at databaseadvisors.com >To: "'accessd at databaseadvisors.com'" >Subject: [AccessD] Setting up a strange report >Date: Thu, 24 Apr 2003 09:49:11 -0400 > >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. >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _____ Add photos to your e-mail with MSN <http://g.msn.com/8HMEENUS/2746> 8. Get 2 months FREE*. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030425/1e0be654/attachment-0001.html>