Search results

  1. N

    difference between two fields in a query

    Thanks dude it worked for me..
  2. N

    difference between two fields in a query

    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...
  3. N

    difference between two fields in a query

    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...
Back
Top Bottom