J
Jordan
I have a list of data that includes information such as; Name, Policy Number,
Original Effective Date, Status and Cancellation Date. There is other
information as well. I am trying to count how many policys I had active in
each month since January of 2003. So if a policy has an Orginal Effective
Date of 03/01/2003 and then was cancelled in 04/01/2005, that policy would
have a count of 1 for each month it was active. I need to show the
information in a grid something like this.
Jan Feb Mar etc.
2003 55 56 67
2004 70 66 42
2005 75 65 60
The problem I'm having is each row needs to be counted for each month it was
active. Not sure how to handle this. Hope this makes sense. Thanks for any
help you might be able to give me.
Original Effective Date, Status and Cancellation Date. There is other
information as well. I am trying to count how many policys I had active in
each month since January of 2003. So if a policy has an Orginal Effective
Date of 03/01/2003 and then was cancelled in 04/01/2005, that policy would
have a count of 1 for each month it was active. I need to show the
information in a grid something like this.
Jan Feb Mar etc.
2003 55 56 67
2004 70 66 42
2005 75 65 60
The problem I'm having is each row needs to be counted for each month it was
active. Not sure how to handle this. Hope this makes sense. Thanks for any
help you might be able to give me.