SQL-PROBLEM

[lode]

Hi,

I've a Access-databasetable, and one of the fields is a date.
How can I retrieve the sum of those records for every month with an sql-instruction.

Thanks
Lode.

 

[elvenmaiden]

&quot;SELECT SUM(Questions)as Question, FROM qryStats WHERE OrigDate >= # &quot; & DTPBegin.Value & &quot; # AND OrigDate <= # &quot; & DTPEnd.Value & &quot; # &quot;

You can either SUM() a field or COUNT() a field over a specific date range.

 

[dalchri]

I would use the following example SQL statement:
[tt]
SELECT Format(YourDateField,'m/yyyy'), SUM(AFieldToSummarize)
FROM YourTable
GROUP BY Format(YourDateField,'m/yyyy')
[/tt]
or if you prefer using fields that aren't overloaded...
[tt]
SELECT Month(YourDateField), Year(YourDateField), SUM(AFieldToSummarize)
FROM YourTable
GROUP BY Month(YourDateField), Year(YourDateField)
[/tt]