GROUP BY sql Statement

[rlsublime]

I have the following sql statement but when i add the group by portion to the entire statment it is giving me an error and not running. any idea what i am missing and what I could do to fix this.



SELECT [IL-FM_HE].[FM/HE], [IL-FM_HE].NAME, [IL-FM_HE]. 2010, [IL-FM_HE].[2011], [IL-FM_HE].[2012]
FROM [IL-FM_HE] GROUP BY "Bank of America Corporation" WHERE[IL-FM_HE].NAME="Bank Of America Corporation" And [IL-FM_HE].NAME="Countrywide Financial Corporation" And[IL-FM_HE].NAME="Merrill Lynch & Co Inc";

[pbaldy]

The syntax is way off. What is it you're trying to achieve? You'd have to group on one or more field names in the SELECT clause, not fixed text. The clause is out of place and I suspect you want "OR" instead of "AND in the WHERE clause.