GROUP BY problem

[Gunnar Swan]

Found my own problem. Must do GROUP BY then ORDER by.
Thanks.

2/21/03 10:28:52 AM, Gunnar Swan <GunnarSwan at PracticeToPass.com> wrote:

>What is wrong with this ...
>I keep getting 603 - Field not found
>
>SELECT fldResponseDate, 
>COUNT(fldResponseDate) 
>FROM tblResponses 
>ORDER BY fldResponseDate 
>GROUP BY fldResponseDate 
>
>When I remove the GROUP BY ... it works.
>
>Any ideas.
>
>
>Best Regards,
>Gunnar Swan
>http://www.PracticeToPass.Com
>Software Built For Statutory Courses
>


Best Regards,
Gunnar Swan
http://www.PracticeToPass.Com
Software Built For Statutory Courses