Calculations Help Urgent!

[UponFrail]

Hey everyone. The situation is i need to produce a report that details, all contracts sold, for each months of 2009. I need to calculate, the total income of the contracts for each month (Which i've done). The total sales, which i can't do. I also need to calculate, the total income for the year 2009. Which i'm struggling on.

I put =Sum([MonthlyCharge]) for the month.

However, i can't find a sum that would calculate, all the total monthly charges for each month, to make it a total for a year.

I also can't seem to calculate the total amount of sales.

The fields are: Duration, ContractStartDate, ContractID, MonthlyCharge.

I need help within the next hour, because i have to go back and produce this, to which i'm stuck on. Any help will be greatly appreciated.

 

[llkhoutx]

Group your report data by month, with the total in the group footer, and the yearly total in the report footer.

 

[Cwittmaack]

If you are having a problem with the formula i had a slight problem, Paul helped me out you can try this for totals
=Sum([ ? ]+([ ? ]+([ ? ]))) mine was this type of calculation =Sum([Sum Of New_Acct]+([Sum Of Dlr_Access]-([Sum Of Disconnect]))) which gave me a total.