William Hindman
dejpolsys at hotmail.com
Sun Sep 25 19:12:16 CDT 2005
..given a record containing the following data: (from a legacy DOS app) field name: EMSID field type: long record data: 44318 field name: Booth Number or numbers (#1) field type: text record data: 649/651/ 748/ 750 field name: Booth Number or numbers (#2) field type: text record data: 653/655/ 657/ 659/ 752/ 754/ 756/ 1358 field name: Booth Number or numbers (#3) field type: text record data: DF-7/DF-8 ..I need to make a new table with the following data structure: (sort order is immaterial) EMSID BoothNum 44318 649 44318 651 44318 748 44318 750 44318 653 44318 655 44318 657 44318 659 44318 752 44318 754 44318 756 44318 1358 44318 DF-7 44318 DF-8 ..I know I've done this before but it was back in the days when my brain cells weren't full of plaque :( ..I've racked my remaining shreds and tried dozens of supposed solutions and am now throwing things at the wall ...some stick :( ..will some poor soul here take mercy on me and end my misery ...other than by shooting me? William ...working waaaaaay too late on a Sunday after watching my Dolphins win today by the hair in their teeth :)