It was fun to try this out. I doubt the SQL will work in VFP, but the logic should work, even if you have to use a SCAN.

>Bob
>
>Your amazing!!!! I had to build a sql table to duplicate what you did, and it appears great. I'm going to build a routine to build a sample table with a lot of data to see speed issues, but thanks.
>
>kirk