Thanks Michael,

yeah this problem is a real pain in the rear, I think I'm going to have to run some subqueries inside foxpro to get my desired results.