GROUP BY problem

Gunnar Swan GunnarSwan at PracticeToPass.com
Fri Feb 21 10:28:53 CST 2003


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




More information about the Valentina mailing list