how to perform a calculation where two operations are needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to perform to different operations on the same set of data based on a
criterion.
Here is my example:
Balance Amount TransactionType
500 25 1
350 300 2

If the TransactionType is 1 we should add the (balance+Amount) however if
the transactionType is 2 we need to subtract.
How do we achieve this?
 
Try

NewFieldName: IIf([TransactionType]=1, [balance]+[Amount], [balance]-[Amount])
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do i deal with this table 0
Access Running Balance in Access 1
Expression subtracts double 4
Running Balance (Debit and Credit) in Access 2007 4
How to create a "point in time" calculation that is date stamped 1
Running Sum in Union Query 2
Calculate interest amount based on average daily balance 1
Vlookup and Type Mismatch 4

Back
Top