Hi Steven!

>> think that one way is you to do 2 select's, thus:
>>Maybe other way woulde you to do Sub-Select in you Select statement, but I think that is only possible in VFP8 or VFP9.
>I hope this help you.
>Erick, Thank you for responding. You are probably right that two queries may be required. I was trying to limit it to one if possible as it is going to used as a recordsource for a report.

See Cetin's answer.
I sleep in the point. I did this other day and I forgot in the answer that I gave you. 8-D
Bye!