>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.