Subtraction of two field values in query

Waheed2008

Registered User.
Local time
Today, 08:32
Joined
Jul 17, 2008
Messages
57
Hi all,
I have got a problem in subtraction of two fields. I have two tables Department & Expense. Department has Name , Budget, etc fields and Expense has all the expenses of these departments.

I a query, I have joined these two tables and sum up all the expenses of Departments. Now I want to add one field in query which will show Remaining Budget of each department.
I have tried the method

Field - Remaining Budget: [Budget] - [Expense]
Total - Expressions

But it does not work. Perhaps there is some Syntax error.
I am attatching the file.
Can sumebody add this field into query ??

Thanks in anticipation.
 

Attachments

Thanks Khawar
I have used this method into my project.
Have a nice day
 

Users who are viewing this thread

Back
Top Bottom