adding totals in report

[OAKLEYS21]

Hello,

I really having a problem, I want to create and accounting balance sheet using the report function in access. I have set up a list of accounts that have a bunch of transactions posted to them. What I want to do is total the transactions for each account and put them in a specific place in the report. For example

Assests

Bank $2,000
Accounts rec 12,000 - displays total for all transactions in the account

Can anyone help me? Thanks.

 

[hneal98]

Are you listing the transactions on the report? If so, just create a new field and list the transaction fields on the new field, adding them together like this:

=[trans1]+[trans2]+[trans3]