I have downloaded out of our system the beginning of an operation that has proved to be very challenging already.

For a group of Properties/Wells in the State of Oklahoma, I have downloaded all the lists of owners that have royalty interests for these properties. Right now, I have about 26,000 owner records, and there are roughly 500 properties that contain these owners. The property number is listed on each of these property records as well as the effective year and month as detailed in the next paragraph.

Each owner's records contains a field that contains an effective year and month expressed in numeric format for example 201001 meaning January 2010.

The operation is to come up with the most recent list of ownership by well using the field Effective year and month(the aforementioned numeric field listed in the previous paragraph), extracted to a separate listing on a separate tab. I don't want to have to do this well by well.

I appreciate your help.