>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) AS YearDate,
MONTH(Date) AS MonthDate,
.............
FROM ....
GROUP BY YEAR(Date),
MONTH(Date)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.