Thanks a lot, I'll try it..

>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