If I do this SQL, it works:

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

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

This is a SQL I have been using for a while. I just can't find what I changed today in it making it to no longer work.