Dummy field and GROUP BY 1

[JerryKlmns]

I 'm trying to execute this sql statement

SELECT 'CIASF' As TableName,
ASF_DATE As DateIn,
Count(*) As Counted
FROM dbo.CIASF
GROUP BY 'CIASF',
ASF_DATE
ORDER BY 2;

using an SQL Pass-Through query from MS-Access. Although for an MSAccess table that would be succesful, I get:
Each GROUP BY expression must contain at least one column reference (#329)
for SQL Server 2005
CIASF is not a field just a column I need to be shown with that value

 

[Otto]

Omit the constant from 'group by'.