Thanks it worked for me good now. And one more thing i am trying to do . (i.e) if the calculated answer is in minus it should go to debit or if it is plus it should go to credit. For this i can create a new query with 3 fields name credit and debit but the values of this plus and minus should be...
hi i have a query created for a table with 3 fields like,
1)name 2)sum of credit 3)sum of debit
Now i need an extra field like
4)sum that is [sum of credit]-[sum of debit] but when i give this in a query if the difference is there then it is coming but if there is no value in debit then the...