Subtracting two records

[laipeka]

Hi I am trying to make a query that sums up the amount of a record and minus the sum from another record. For example,
Amount Budget
12 100
100
10.5
5
Sum=27.5
minus the sum of Amount from the budget which I will get 100-27.5=72.5. Is this possible?



Please I need your help. Really appreciate any help.

Thanks

[June7]

Review http://allenbrowne.com/subquery-01.html
Look at the example: Get the value in another record

[A S MANN]

You can create a field in select Query Difference:[Budget] -[Amount]
Than create a aggreegate query with Sum of Difference as your anwser.