>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?
Can this help you:
SELECT Month([Actual_Class_Date]) as MMClass, Year([Actual_Class_Date]) AS YYClass, Sum(tblTransactions.Current_Charge) AS SumOfCurrent_Charge
FROM tblTransactions
GROUP BY Month([Actual_Class_Date]), Year([Actual_Class_Date])
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com