Well what d'ya know!

But I didn't think it was exactly what you were looking for. I thought you wanted it in one SQL statement.

>YES FINALLY!!! It worked!!! Exactly what I was looking for!!!
>
>-Thanks VERY MUCH!
>
>- Thanks to everyone else that tried to help too! I feel better that even though I've been a full time fox programmer since 1994 I don't feel so bad that I didn't know this right out.