New to the boad, and need help with running this query.
On the TABLE I have 2 fields to be concerned with
DATE RECEIVED and DATE CLOSED
10/11/06 10/15/06
9/12/06 9/13/06
10/16/06 10/18/06
9/10/06 9/19/06
I need to run a query that can tell me how many items were closed between. .
1-5days= Amount closed between that date range.
6-10days= Amount closed between that date range
<11 = any thing closed 11 days or longer.
So the end rusult might look something like this..
1-5 days 3
6-10 days 1
<11 days 0
I will need to run this query on a weekly basis... Also I have only completed Access level II.... So if you could use layman's terms to help me that would be great. .
Thanks in advance,
Craig
On the TABLE I have 2 fields to be concerned with
DATE RECEIVED and DATE CLOSED
10/11/06 10/15/06
9/12/06 9/13/06
10/16/06 10/18/06
9/10/06 9/19/06
I need to run a query that can tell me how many items were closed between. .
1-5days= Amount closed between that date range.
6-10days= Amount closed between that date range
<11 = any thing closed 11 days or longer.
So the end rusult might look something like this..
1-5 days 3
6-10 days 1
<11 days 0
I will need to run this query on a weekly basis... Also I have only completed Access level II.... So if you could use layman's terms to help me that would be great. .
Thanks in advance,
Craig