Myron: Here's a thought. Can you use "LISTOF"? If you had a table with a FullName column, you can do a SELECT (LISTOF(fullname)) INTO variable WHERE householdid = .... You could create a view or temp table with the results of LISTOF with a GROUP BY parameter. If you want a separator other than a comma, I'd probably first get rid of any embedded commas in the fullname (like Will Jones, Jr) and then after the Listof you could replace a comma with your separator.
Karen -----Original Message----- From: [email protected] To: [email protected] Sent: Fri, May 6, 2022 9:38 am Subject: RE: [RBASE-L] - Put together two rows of data from one table <!--#yiv3240988119 _filtered {} _filtered {} _filtered {} _filtered {}#yiv3240988119 #yiv3240988119 p.yiv3240988119MsoNormal, #yiv3240988119 li.yiv3240988119MsoNormal, #yiv3240988119 div.yiv3240988119MsoNormal {margin:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv3240988119 a:link, #yiv3240988119 span.yiv3240988119MsoHyperlink {color:blue;text-decoration:underline;}#yiv3240988119 span.yiv3240988119EmailStyle21 {font-family:"Calibri", sans-serif;color:windowtext;}#yiv3240988119 .yiv3240988119MsoChpDefault {font-size:10.0pt;} _filtered {}#yiv3240988119 div.yiv3240988119WordSection1 {}-->Bruce,There is a key column (PropertyID) in the table (housedetail) that identifies each individual house (roof) and each person in the house. So, if you were to look at my house you would have two rows of data identified by the ‘PropertyID’ key. Goal for the address header: Myron Finegold and Susan Shapiro (or any other variation)15132 Blackgold Ln.Sun City West, AZ 85375 Best regards, Myron Finegold15132 W Blackgold LnSun City West, AZ 85375 From: [email protected] <[email protected]> On Behalf Of Bruce Chitiea Sent: May 5, 2022 5:28 PM To: [email protected] Subject: Re: [RBASE-L] - Put together two rows of data from one table "... two rows of data identified by a unique number." To be clear, is this a key value common to the two rows, e.g. "householdID"? as in: 10001 | party110001 | party2 Did this for a series of gala invitations a while back, happy to dig it up tonite. Best, Bruce Bruce A. Chitiea | SafeSectors, Inc.112 Harvard Ave #272 | Claremont CA 91711-4716 | USA+011 (909) 238-9012 m | [email protected] ------ Original Message ------From [email protected] [email protected] 5/5/2022 5:17:42 PMSubject [RBASE-L] - Put together two rows of data from one table Goal: To creating an address label that has two separate names concatenated – for a mailing label. For example: Myron Finegold and Susan Shapiro. (The street information and the city and state are easy)The data: We have a table that tracks the owners of a house. (we have about 17,000 houses and 30,000 rows of data) So, if there are two owners there will be two rows of data identified by a unique number. Party 1 – first name and last name and other information; Party 2 first name and last name and other information.I’ve never done this and I’m not sure where to start. What is the best way to pragmatically do this?Thanks in advance. Myron Finegold / Sheriff’s Posse of Sun City West -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/000401d860de%24b480dd60%241d829820%24%40gmail.com.-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/em3816b5d7-280a-4fe2-b37d-e6c7fea2d9fe%40e1947d0a.com.-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/019001d86156%24ff5bd600%24fe138200%24%40gmail.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/251407538.215251.1651848427368%40mail.yahoo.com.
