Are you using VFP9? I tried yesterday to create a test in VFP8, but could not make it to work. I had the idea similar to John's, but decided to not present it here, since I don't know how many groups you may have.
>Hi Sergey,
>
>I tried your solution, but get "Queries of this sort are not supported" error.
>
>Regards
>Doug Johnston
If it's not broken, fix it until it is.
My Blog