Another access to mysql query

[Ettienne Jolliffe]

I have problem with the following query:

SELECT tblCustomers.mcID, tblCustomers.mcFirstname, tblCustomers.mcLastname, tblCustomers.mcType, tblContactInfo.ContactType, tblContactInfo.ContactDetails, tblContactInfo.ContactDefault, Sum(iif(isnull(tblClaimed.Points) = true,0, tblClaimed.Points)) AS SumOfPoints, tblClaimed.Used, tblPoints.TotalPointsEarned, iif(tblPoints.TotalPointsClaimed=null,0,TotalPointsClaimed), (TotalPointsEarned-(TotalPointsClaimed+SumOfPoints)) AS probeer FROM ((tblCustomers LEFT JOIN tblContactInfo ON tblCustomers.mcID = tblContactInfo.mcID) LEFT JOIN tblClaimed ON tblCustomers.mcID = tblClaimed.mcID) LEFT JOIN tblPoints ON tblCustomers.mcID = tblPoints.mcID GROUP BY tblCustomers.mcID, tblCustomers.mcFirstname, tblCustomers.mcLastname, tblCustomers.mcType, tblContactInfo.ContactType, tblContactInfo.ContactDetails, tblContactInfo.ContactDefault, tblClaimed.Used, tblPoints.TotalPointsEarned, tblPoints.TotalPointsClaimed Having (((tblContactInfo.ContactDefault) = true ) And ((tblClaimed.Used) = 0 Or (tblClaimed.Used) Is Null)) ORDER BY tblCustomers.mcType

It keeps on telling me: Unknown column 'SumOfPoints' in 'field list'


Thanks