>But, if I add an HAVING clause, I have an error on the HAVING clause complaining that it is invalid:
>
>

>SELECT Affiliate.NoMember,SUM(Affiliate.Amount) AS Amount,MAX(Member.Numero) AS Numero,MAX(Member.FirstName) AS FirstName,;
> MAX(Member.LastName) AS LastName;
> FROM Affiliate;
> INNER JOIN Member ON Affiliate.NoMember=Member.Numero;
> WHERE Affiliate.Period<=ldDate AND Affiliate.NoCheque=0;
> GROUP BY NoMember;
> HAVING Amount>100
>

>

Amount is ambiguous here; are you referring to the SUM you just computed or the original Amount field. Try using SUM(Affiliate.Amount) in the HAVING clause instead.

Tamar