Option 1. Make a summary report where you put your line of fields in the sub summary part when sorted by Acct. The various total fields such as total debits would be summary fields. Delete the body layout part by clicking the body part label and pressing the delete key. Now enter browse mode, find the records you need for your account and sort them by the Acct field. With the body layout part removed, you'll get one row per acct.
Option 2. Create a new table where you have one record for each acct. Relate it to the original table by acct. Now calculation fields defined in this table can use Sum to total various fields such as total debits and credits. A list or table view layout of this table will also give you the same results.
Thank you very much. Option two has done the job and very nicely too. I'm not sure why I didn't think of it. I now have the data to bring into the other table as well.
Thank you so much both for the quick response and the insight....