Aggregate function in ms access does not work in my budget program

[alamnizamani]

I am trying to prepare a mini budget program in ms access for my personal use in my office , but every time i fail to do so, is there any one who can help me in this regard my tables are as under
Field Name Properties
Code ID AutoNumber


001 Cash
002 Bank
846 conveyence
dt: Date/time
Code text (list selected by drop-down list)
des Description
Bill currency
yearly Budget currency
quartlyBudget currency



Query Question:

Group Aggregate function in my Budget data base file

(A) (B) (C) (D) (E)
Code yearlyBudget quaterlyBudget quaterlyused Budget Available Budget
846 50000 12500 5000 7500
850 100000 25000 20000 5000

There are 100 entries in code no. 846 and 50 entries in code no.850 the above given amount is total of each code no.
my question is that how can i get result subtracting amount in column (D) from column (C) to get result in column (C)

Budget Available: in Code 846 i.e column (E)

[June7]

Can have an expression in that query:

Sum([C]) - Sum([D])

Consider building a report using grouping & sorting with aggregate calcs. This will allow display of detail records as well as summary calcs.

[alamnizamani]

Sir, I have done as you advise me but i receive the following error message i.e
Can not have aggregate function in expression (sum(sum([Credit])-([Debit])))
I typed this in my last column Expr1: Sum([Credit])-Sum([Debit])

Thanks

[June7]

Did you change the Total row under that calculated field to Expression?