Search results

Please look at the example table below. I need to get the total counts of the consecutive months for each Fname. Please help. Results should be: Fname Total Consecutive Count John doe 4 Test 2 Fname Fdate john doe 10/1/2008 john doe 9/1/2008 john doe 8/1/2008 john doe 7/1/2008 john doe 5/1/2008...