MS Access Distinct problem!

[NoviceDBLearner]

I need to be able to get rid of the duplicate artists before I count them due to the fact that I will get duplicates in the SQL result window which I don't want. What do I write in order to make this work. I am aware of that distinct gets rid of the duplicates. Can somebody please help me write the syntax for this. I have been trying different solutions which I've found with google but none of them seem to work. I keep getting syntax errors.

SELECT DISTINCT exhibitionname, COUNT(Artist) AS number
FROM Exhibition, ExhibitionTime, Artwork
WHERE Exhibition.ExhibitionID=ExhibitionTime.ExhibitionI D And Artwork.ArtID=ExhibitionTime.ArtID
GROUP BY exhibitionname;

Thanks :)!

[mshmyob]

Try something like this.

SELECT DISTINCT Count(tblName.fldName) AS CountOffldName1
FROM tblName
ORDER BY Count(tblName.fldName);
 

cheers,

I need to be able to get rid of the duplicate artists before I count them due to the fact that I will get duplicates in the SQL result window which I don't want. What do I write in order to make this work. I am aware of that distinct gets rid of the duplicates. Can somebody please help me write the syntax for this. I have been trying different solutions which I've found with google but none of them seem to work. I keep getting syntax errors.

SELECT DISTINCT exhibitionname, COUNT(Artist) AS number
FROM Exhibition, ExhibitionTime, Artwork
WHERE Exhibition.ExhibitionID=ExhibitionTime.ExhibitionI D And Artwork.ArtID=ExhibitionTime.ArtID
GROUP BY exhibitionname;

Thanks :)!