How to get total of column in report

[markajem]

I have created a simple report that shows a bank account statement. I have my selected columns appearing correctly as in Payee, Transdate, etc but I also have two columns called Debits and Credits. If the transaction is a debit it appears in the debit column and the same for credits. My problem is probably very easy but can't figure it out. I am trying to create a total for each of the columns; a total for credits and a total for debits. I have it sorting by months then days which is working well but wanted to show the total for each debit and credit by month. I tried placing totals in the group footer(by month) but I just can't figure out what to do here. My credits and debits are appearing properly as they should in their columns with my =IIf statements; just can't get those totals to appear.

Thanks
Mark
Mark
Email: markanas333@hotmail.com

 

[CosmoKramer]

In your group footer, place an unbound text box with a control source something like this:

=Sum([debits])

 

[markajem]

Thanks but I believe I have tried something like this already. In my table of transactions I have a field named "transactionamount". Then in the report I do an IIF statement to determine which column to place the transactionamount in. So as the report runs thru the records it determines which column to place the transaction amount in. If I place the code =sum([credits]} would I not need a variable named credits predefined. Sorry, still a little lost. i am used to working with Crystal and with that all you do is right click on the detail line amount and then click insert group total and it automatically inserts the total in the group footer. Mark
Email: markanas333@hotmail.com