Hi Alex.. thanks for your reply.
I've had a look at FaxtXTab and it seems to do the job!!
Regards,
Gerard


>>Is there any Cross Tab utility in VFP 9.
>>(I vaguely remember a XTAB.app in 2.6 I think)
>
>See:
>
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp9/html/1eb886bb-09e2-46e9-b22a-6ee301cb3bb3.asp
>http://fox.wikis.com/wc.dll?Wiki~CrossTab
>http://fox.wikis.com/wc.dll?Wiki~FastXTab
>http://fox.wikis.com/wc.dll?Wiki~MatXTab
>http://fox.wikis.com/wc.dll?Wiki~PivotTables
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp9/html/ba4aa222-eb9b-4acd-99b6-fa70fa0f952e.asp
>
>You can easily control the powerful Excel Pivot Tables programmatically if you have Excel installed.
>
>HTH