Find specific rows based on data in two linked rows

[#1]

I have a table with some with paired rows. Where I have to select paired rows based on two fields in each row. I am stumped. Can some body please help?

Thanks,

[kamalqlik]

Please make it more clear!I am not getting that what you want as a answer