Hi Jonathan,

Try using the Cross Tab query from the visual foxpro.
You can use it from Tools-->Wizards-->All-->CROSS-TAB QUERY.

Try to prepare the crosstab query and then use its sql syntax in your program.



---
Raj