Problem using derived column name in Group By
Posted on 2006-06-29
Running Access 2K as a back end using SQL via ODBC and having difficulty using a derived column name in a Group By clause.
select count(*) as cnt, counselorid, mid(shortdate,6,2) + "/" + mid(shortdate,1,4) as newdate from meetings group by newdate, counselorid;
Error msg is:
You tried to execute a query that does not include the specified expression 'mid(shortdate,6,2)+[/]+mid(shortdate,1,4)' as part of an aggregate function.
Can't figure out what's wrong.