>>>The memo field is not allowed in the group by but is also not allowed in the result set. (this one bit me recently as well ) It would be meaningless in any case, unless it is the same for every record.
>>
>>Thanks for helping me with this clarification. Because the memo fields were from the 'child' linked table, they were the same. This will be one for the memory bank.
>
>You might try MAX(memofield). Ran into that recently but can't remember if it worked or not.

MAX() of a character column where all the values are known to be the same just seems "incoherent", doesn't it? ;)