GROUP BY problem

[Frank Bitterlich]

Don't kknow why you're getting exactly this error, but doesn't the
"GROUP BY" automatically include the "ORDER BY"?

In either case, if you change the order of the GROUP BY and ORDER BY
clause, it will work.

Cheers,
   Frank+++

Gunnar Swan 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.


--
Günter Schmidt & Co. oHG         
Frank Bitterlich             eMail: bitterlich at gsco.de
Schlosserstr. 4              WWW:   http://www.gsco.de/gsco
D-60322 Frankfurt            Tel.:  069 / 156809-29
GERMANY                      Fax:   069 / 156809-28