Hi,

I do have the following data

Tx ID     Patient Payer
300     10001     2000
301     10001     2000
302     10001     2000
303     10001     2001
304     10001     2001
305     10001     2001
306     10001     2002
307     10001     2002

I would like to know whenever there is a change in payer for that patient I would like to report it.Finally my data should look something like this

                     Payer     
Patient     Current Payer     old     new
10001     2002             2000     2001
10001     2002             2001     2002

I am not sure where to start this report any help will be greatly appreciated.

Thanks,

Can you also suggest me how to do a comparison as I only need to report rows when a payer was changed

Thanks

Thanks but I couldn't able to get an idea of how to get Old,new, current payer in the scenario which I gave