Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Math SUM() - - Database amounts lack positive / negative
0 views
Skip to first unread message
Dig314
Aug 19, 2004, 4:32:46 PM8/19/04
to
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:
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
0 new messages