Yes, exactly ... -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dave Crozier Sent: 02 December 2011 12:05 To: [email protected] Subject: RE: Report design problem
So you only want to attach the children to the last Parent of a group? Is that what your problem is? Dave -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paul Newton Sent: 02 December 2011 11:57 To: [email protected] Subject: RE: Report design problem OK Let me re-post with what the data might really look like: I have two tables with the following records: parent.p_id parent.p_desc 1 Fred 1 Mary 2 Jonathan 2 David child.c_id child.c_county 1 Essex 1 Surry 2 Devon 2 Cornwall I need a report that looks like this: Parent Heading Fred Mary Child Heading Essex Surry Parent Heading Jonathan David Child Heading Devon Cornwall [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
