Cheers all.
Thanks in advance
- I received a table that broke a text field into several columns (text1, text2, etc.) Furthermore, once a certain textfield number (Text14) was reached, the programmer created a new record to continue the text...so text that would have gone into Text 15, went into a new record's Text1 field and continued from there.
- Each record is distiguished by different values in a "Line_Set_Num" field (record 1= 001, record 2=002, etc.) This is not a record ID.
- I managed to concantonate (sp?) the text in Text1-Text14 into a new field I created ("ALLText" - memo), but now need to merge the ALLText from from the multiple records and empty or remove the surplus records.
- I'm attaching a sample db that contains a table that represents the data as I recevied it. A second table with where I'm at with the data. And a third table dispalying the desired outcome. Please note how Line Set Numbers 002-004 have been removed in table 3.
Thanks in advance