Right, so in priority order:

1. There may or may not be a period date (TranPeriod). When there is a matching period date for both transaction types and the amounts cancel,...

INT is fine for this example. When there is a date it is stored YYYYMMDD.

Thanks for the response.

Let me see if I can clear it up a bit:

TranSeqMatching TranSeq

1Unmatched

25

34

43

52

67

76

89

98

1011

1110

12Unmatched

The Quirky Update seems to be doing the trick very nicely. I still have some further testing, however, the initial results look correct.

My original code has been running for over...

Drew:

Wow! The Quirky Update is totally awesome!

I am off to code. I'll let you know how it goes.

Chris:

I will certainly keep in mind your suggestions when I post issues in...

Thanks. I will have a look.

I know to avoid cursors, but just couldn't get my head around how to do it without one (or two in this case).