>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!

What about my answer?! <g>