I have the below query running access:
SELECT v.sum_month AS [Month], Sum(v.x) AS [Open Dates], Sum(v.y) AS [Closed Dates]
FROM (SELECT format(t.[Date],'yyyymm') as sort_month, format(t.[Date],'mmm yyyy') as sum_month, 1 as x, 0 as y
FROM Central_Reporting_System_Register t
SELECT format(t.[Date Closed:],'yyyymm') as sort_month, format(t.[Date Closed:],'mmm yyyy') as sum_month, 0 as x, 1 as y
FROM Central_Reporting_System_Register t) AS v
GROUP BY v.sum_month, v.sort_month
ORDER BY v.sort_month;
1. I want to be able to basically modify this query where it doesn't show the top row. The top row is basically not showing the correct info.
2.At the bottom of the sum fields ( open date and closed date) i want totals for that column. So basically a total number of open dates and a total number of closed dates. Please bare in mind the sum of both these fields has to exclude the top row.
As you probably already know i didn't write the above script it was actually given to me by an expert on this website. So any help on this matter would be greatly appreciated.