Doug: I put your code in my "bag of tricks" file! You're right, having to find missing check numbers and invoices is rather common, and I took the "easy" way out by just declaring a cursor. I have to actually dissect what these views are doing...
And good for you for finding a generic way to do it! Karen
