>Yes You must add all those fields in GROUP BY clause
>Or just before SELECT put
>
> SET ENGINEBEHAVIOR 70
> SELECT ....
> SET ENGINEBEHAVIOR 80
>
You see, one of the fields is a MEMO field and I don't think you can include in Group By. And if I use SET ENGIN... to 70 then the Memo field I need will be a random selection.
That's why I think Peter's approach should work but I am still having a problem there.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham