Hi all,

Hi have a table of records, each record is an action with 2 fields, a field with the date when the action was opened [DATE] and a field with the date when the action was closed [CLOSE OUT DATE].
I need to build a bar chart inside a report, where i have the count of the closed out actions in a month and next to it the count of the opened actions in the same month, all this for every month of the year (X-AXIS).
I tried different solutions but i can't find the way.


You can find attached an image with an example, right now it is not working as it should, it shows the same numbers everytime for closeout and opened records.

Chart SQL COde is:

SELECT (Format([DATE],"MMM 'YY")) AS Espr1, Count([SHOC global project query].DATE) AS ConteggioDiDATE, Count([SHOC global project query].[CLOSE OUT DATE]) AS [ConteggioDiCLOSE OUT DATE]
FROM [SHOC global project query]
GROUP BY (Format([DATE],"MMM 'YY")), (Year([DATE])*12+Month([DATE])-1);

I made this with the chart wizard.

Can someone help me?