Complex query

Joined
Jun 7, 2010
Messages
1
Reaction score
0
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top