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
Alek Massey
- The only stupid question is one left unasked -