>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.