look at the vfp help file for 'select - sql' paying close attention to the 'group by' statement.

If I understood you, some similart to the following will be what you will need to use, of course I don't know your field or alias names.


select transid, incometype, amount from yourtable order by transid, incometype group by transid, incometype


hope this helps
Alek