>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.
If it's not broken, fix it until it is.
My Blog