Show cumulative items per month not by day

[Ed]

I want to show cumulative items per month but this is showing by day???

[ECD] is a date field.

[ECD Cum] is an alias for the cummulative result



I want to count the number of actions items in a month that have a date.



SELECT (SELECT
count([ecd])
FROM
[tblActionItems] AS [Self]
WHERE
[Self].[ecd] <= [tblActionItems].[ecd]) AS [ECD Cum], tblActionItems.ECD
FROM tblActionItems
ORDER BY tblActionItems.ECD;

 

[Guest]

hi,
you need a group by on the date.

 

[Ed]

It already works on the date, its 'by month' that I want to group by. That
is what I do not know how to do.

hi,
you need a group by on the date.

-----Original Message-----
I want to show cumulative items per month but this is showing by day???

[ECD] is a date field.

[ECD Cum] is an alias for the cummulative result



I want to count the number of actions items in a month that have a date.



SELECT (SELECT
count([ecd])
FROM
[tblActionItems] AS [Self]
WHERE
[Self].[ecd] <= [tblActionItems].[ecd]) AS [ECD Cum], tblActionItems.ECD
FROM tblActionItems
ORDER BY tblActionItems.ECD;




.