Grasshopper,

That works, thank you! I don't understand why, so I am going to read up on how this query is constructed. 🙂

Thank you again.

I suppose another alternative would be to use a subquery where TransactionNumber not in (identify groups with count(*) = 1 and CancelDueToCorrection = 'Y')