Thank you all for your responses. I knew that this could be quite a difficult problem, but my needs are a bit less substantial. I think we currently have only a couple thousand records, and if it doesn't happen to work exactly right for every single case, those changes can be made by hand. I think I have enough to get where I need to be. Thanks again everyone.

Eric