SQL - Using 'HAVING' to select MAX of a column I created earlier.

[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);

But, it comes up with a 'Enter Parameter Value' box. I sort of get what its doing - it isn't finding the 'CountofDate' column I made earlier right? Well what do I need to do?
Thanks.

 

[nickodvz]

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?
Thanks again.

 

[fredericofonseca]

This is the ANSI SQL forum, and by your post it seems you are working with Access. You should post this on the correct forum, probably forum709.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[nickodvz]

Oh right, apologise. Thankyou.