Hello everyone,
I am new to access and I need to find a query that returns a count of a field grouped by the difference between two dates.
So I have a calculated date that tells me how many days elapsed between opening a request and closing the request, for every unique datediff value I want to know how many requests there are.
My query looks like this:
SELECT DISTINCT DateDiff("d",GRS_Chiuse.RICH_DATE,GRS_Chiuse.DATA_CHIUSURA) AS Espr1
FROM GRS_Chiuse ;
The above query tells me all the distinct values there are between two dates, now I want to know how many services there are for each unique date difference.
So my query should tell me how many requests were closed within 2 days etc..
How do I do it?
I am new to access and I need to find a query that returns a count of a field grouped by the difference between two dates.
So I have a calculated date that tells me how many days elapsed between opening a request and closing the request, for every unique datediff value I want to know how many requests there are.
My query looks like this:
SELECT DISTINCT DateDiff("d",GRS_Chiuse.RICH_DATE,GRS_Chiuse.DATA_CHIUSURA) AS Espr1
FROM GRS_Chiuse ;
The above query tells me all the distinct values there are between two dates, now I want to know how many services there are for each unique date difference.
So my query should tell me how many requests were closed within 2 days etc..
How do I do it?