Show cumulative items per month not by day

  • Thread starter Thread starter Ed
  • Start date Start date
E

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;
 
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;




.
Click to expand...
Click to expand...
 
Back
Top