I have an Access 97 database that I connect to via ADO in VB. In Access I can do the following query syntax and it works:

SELECT Format([Actual_Class_Date],"mmm-yyyy") AS Class_Month, Sum(tblTransactions.Current_Charge) AS SumOfCurrent_Charge
FROM tblTransactions
GROUP BY Format([Actual_Class_Date],"mmm-yyyy");

However, in my ADO SQL statement this does not work. I know in SQL Server you can use the DATENAME function but I need to figure out a way to do it when talking to Access 97. Any suggestions?