C
Clemens
I have a tabel with 2 fields.
I have created a query where I count all records per year and per month
based on the field 'Open date'.
SELECT Year([Open Date]) AS Year, Month([Open Date]) AS Month,
Count(SCexport2.[Change No]) AS [CountOfChange No]
FROM SCexport2
GROUP BY Year([Open Date]), Month([Open Date])
ORDER BY Year([Open Date]);
I have created another query where I count all records per year and per
month based on another field 'Close Time'.
SELECT Year([Close Time]) AS Year, Month([Close Time]) AS Month,
Count(SCexport2.[Change No]) AS [CountOfChange No]
FROM SCexport2
GROUP BY Year([Close Time]), Month([Close Time]);
All records have an 'Open Date', but not all records have a 'Close Time'
(these records are still open). So the total count of the Open Date query
should report more records than the 'Close Time' query.
I can perfectly create a pivot chart based on 1 of these queries, but I need
to create 1 pivotchart where compare the amount of records with an 'Open
Date' next to the amount of records with a 'Close Time'
I have created a query where I count all records per year and per month
based on the field 'Open date'.
SELECT Year([Open Date]) AS Year, Month([Open Date]) AS Month,
Count(SCexport2.[Change No]) AS [CountOfChange No]
FROM SCexport2
GROUP BY Year([Open Date]), Month([Open Date])
ORDER BY Year([Open Date]);
I have created another query where I count all records per year and per
month based on another field 'Close Time'.
SELECT Year([Close Time]) AS Year, Month([Close Time]) AS Month,
Count(SCexport2.[Change No]) AS [CountOfChange No]
FROM SCexport2
GROUP BY Year([Close Time]), Month([Close Time]);
All records have an 'Open Date', but not all records have a 'Close Time'
(these records are still open). So the total count of the Open Date query
should report more records than the 'Close Time' query.
I can perfectly create a pivot chart based on 1 of these queries, but I need
to create 1 pivotchart where compare the amount of records with an 'Open
Date' next to the amount of records with a 'Close Time'