>I need help creating an SQL statement where the records sum certian fields and is grouped by the YEAR and MONTH of a date field.

SELECT YEAR(DATE()),MONTH(DATE())  FROM anytable GROUP BY 1,2
SELECT YEAR(DATE()),MONTH(DATE())  FROM anytable GROUP BY YEAR(DATE()),MONTH(DATE())

MartinaJ