>
>
>In other words, all fields not listed in Group By should have some aggregate function. If these fields are memo fields, then you're out of luck.

Thanks for your response. There are some memo fields included. So I have to add an other outer join to the query for these fields to solve it? I didn't think about this...