No, the table does not have a primary key. The Memos whithin a group are also equal to the last character.
The table could have this values:
F1, F2, F3, F4, F5 (memo)
Walter Meier, Hallo Walter, 20120101, 20121231, complete adress with multible lines for Walter Meier
Walter Meier, Hallo Walter, 20120101, 20121231, complete adress with multible lines for Walter Meier
Walter Meier, Hallo Walter, 20120101, 20121231, complete adress with multible lines for Walter Meier
Walter Meier, Hallo Walter, 20120101, 20121231, complete adress with multible lines for Walter Meier
Gesine Huber, Liebe Gesine, 20120101, 20121231, complete adress with multible lines for Gesine Huber
Gesine Huber, Liebe Gesine, 20120101, 20121231, complete adress with multible lines for Gesine Huber
Gesine Huber, Liebe Gesine, 20120101, 20121231, complete adress with multible lines for Gesine Huber
What I need is a table like that:
Walter Meier, Hallo Walter, 20120101, 20121231, complete adress with multible lines for Walter Meier
Gesine Huber, Liebe Gesine, 20120101, 20121231, complete adress with multible lines for Gesine Huber
TIA
Gerhard
>>Thank you Naomi,
>>
>>I tried your code and did not get an error any longer. But I get all records, no grouping occurs at the final result.
>>
>>Any other idea?
>>
>>TIA
>>Gerhard
>
>
>Does your table have Primary key? Can you post its structure and what fields make the row unique?
>
>Also, will first 250 characters of the memo column be enough to make the row unique?
>
>If so, there is a simple adjustment to the idea I showed.
Gerhard Schmidbauer
URANUS Software GmbH