Tracking the people that paid full price after buying with a discount.

[Please]

Good morning,

I'm looking back a couple years in payment history and trying to pull the number of people who originally paid with a discount and then paid full price the next payment they made.

Sample date

Date	Account	Name	Old Exp	New Exp	Pay From	Discount	Payment	Publication
10/3/2008	2	Bob Man	9/28/2008 <tbody> </tbody>	12/29/2008 <tbody> </tbody>	9/29/2008 <tbody> </tbody>	0	30	YZK
10/3/2008	45	Chris Man	10/22/2008 <tbody> </tbody>	1/22/2009 <tbody> </tbody>	10/22/2008 <tbody> </tbody>	0	30	YZK
10/3/2008	3333	Chris Mans	10/23/2008 <tbody> </tbody>	1/23/2009 <tbody> </tbody>	10/23/2008 <tbody> </tbody>	0	30	YZK

<tbody>
</tbody>

Some more information about the data set I have.
Dates range from 10/3/2008 until today, Names are unimportant, Discount and Payment can both be zero, there are 13 different publication codes.