Waheed2008
Registered User.
- Local time
- Today, 10:07
- 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.
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.