I need to Total the amounts for each Property ID in a table.
All the amounts are stored as positive in the database.
Based on a transaction code, the amount should be added or subtracted.
There are about 14 transaction codes, but here is an example:

Transaction Code "Addition" - - add the amount
Transaction Code "Disposal" - - subtract the amount

Can this be done in single select statement ?

Thank you for your assistance!

Dig