I'm working on a project using an Access back end, and for the life of me I cannot get it to accept a COUNT(DISTINCT Anything) query. Is this unsupported in Access or is there something wrong with my syntax? When I do a simple count, it works fine.

Here's the query I'm trying to send (I pulled it out of the immediate window so it's actually readable).

SELECT LivingSituations.Description, COUNT(DISTINCT Relationships.ProtegeID) AS NumberProteges
FROM Relationships INNER JOIN (LivingSituations INNER JOIN RelationshipReview ON LivingSituations.LivingSituationID = RelationshipReview.LivingSituation) ON Relationships.RelationshipID = RelationshipReview.RelationshipID
WHERE (((RelationshipReview.ReviewID)=1))
GROUP BY LivingSituations.Description;