I have created a table which logs a number of downloads for specific documents:
DownloadID DownloadDate DocumentID

I want to be able to list a count of all the Downloads by documentID

So if DocumentID '3' has had a downloadID record created 3 times it shows 3 and so on. I can get it so I have a total record count but I want to break the count down via DocumentID. Solutions would be greatly appreciated.

Here

SELECT DownLoad.DocumentID, Count(DownLoad.DownLoadID) AS CC
FROM DownLoad
GROUP BY DownLoad.DocumentID;

CC will hold the count of the DocumnetID