>>>
>>>
>>>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...
>
>Yes, you may try to re-write your select this way:
>
>select * from Table1 inner join Table2 on Table1.Pk = Table2.fk ;
>inner join (select Pk, Min(date) as MinDate from Table2 group by 1) ;
>MinDate on Table2.Pk = MinDate.Pk
Naomi, if pk is a primary key, group by is useless