>What would be a good way to do a SQL query if I have a date field in my table and I want to gather informations based on the months. I mean there could be data in the month of november 2008 but also november 2007.
>
>How can I manage to get the sum for november 2007 and then november 2008 all in the same query?

SELECT YEAR(Date)  AS nYear,;
       MONTH(Date) AS nMonth,;
       SUM(....)   AS SomeTotal;
FROM YourTable;
GROUP BY 1,2;
INTO CURSOR crsTest