>I'm using FasXTab with these parameters: rowfield=nTrans, colfield=cAcctno and datafield=nDebit.
>
>How can I use it to create a cursor with two data fields (nDebit and nCredit)?
>
>TIA.
I don't think the original code of FastXTab allowed pivoting on multiple data fields. You can probably adjust the code for your particular case.
Also, if the group values are predefined (you know them in advance) you can simply write it using IIF statements.
If it's not broken, fix it until it is.
My Blog