Paul I made a mistake posting the first code. I ommit the GROUP BY clause, so if you use it in VFP it must be:
SELECT *, SUM(Amount) AS TotalAm GROUP BY Account FROM MyTable INTO CURSOR ReportCursor
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.