Some calculations on a table

• • Reply

  15 years ago

  by mychitterman

  imi

  Champs Fleurs, Trinidad and Tobago

  Joined 15 years ago

  i have a table with these colums:

  Balance   TransactionAmount   TransactionType        NewBalance

  200          25                                 1                              225

  200         40                                    2                              160

  what i want to do is make a query that will calculate the new balance as follows:

  if the transactionType is 1 it will add the Balance+TransactionAmoun

  if the transactionType is 2 it will get the difference

  please help

  Report abuse
• • Reply

  15 years ago

  by sallu_shan

  Arsalan Tamiz

  Karachi, Pakistan

  Joined 15 years ago

  SELECT Balance, TransactionAmount, TransactionType,
  IIf(TransactionType = 1, Balance + TransactionAmount, Balance - TransactionAmount) AS NewBalance FROM TableName
  

  Report abuse