hewitg 82815 (12/4/2014)
I have a table that is set out like so :AccountNoOpenDateCloseDate
136167703/10/201202/01/2014
136177105/10/201219/02/2013
136240905/10/201217/01/2013
138000319/10/201208/01/2013
138180122/10/201229/01/2013
138118122/10/201215/07/2013
138849024/10/201215/07/2013
138863724/10/201205/07/2013
138871824/10/201215/07/2013
137740924/10/201208/01/2013
136221524/10/201215/07/2013
What I am currently trying to do is create a table that shows how many accounts where open per month for this year.
So if I had 10 accounts in Jan that where open. 12 in Feb, 10 Closed in March and No change in arpil it would look like so:
MonthLiveACs
Jan-1410
Feb-1422
Mar-1412
Apr-1412
Please can someone help. Ive driven myself nuts trying different queries.
What's the closedate status of a live account, would it be null.
Logically, if the closedate is after the check month or is null then it is or at least was, a live account?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉