Access SQL - Select maximum number of times date appears. 1

[nickodvz]

Ok, I'm pretty new to this stuff - but I need a bit of help.
Here is my query so far:

SELECT Collars.Date, Count(Collars.Date) AS [CountofDate]
FROM Collars
GROUP BY Collars.Date
HAVING max(countofdate);

Hold on, maybe I've got it wrong.
What I want to do is, select the maximum number of jobs done in a day (each job has its own entry, so there are multiple entries of the same date, I want to count how many times each date is there - and then select the max from this) how do I do this in one query? I can't remember, is there a way to create a temporary table? In which case - how do I do that for what I need?
Thanks for your help.

 

[Golom]

SELECT TOP 1 [Date], Count([Date]) AS [CountofDate]
FROM Collars
GROUP BY [Date]
ORDER BY 2 DESC

 

[nickodvz]

Ok. You are awesome. Thank you very much.