L
ljp1215
Table A contains the following fields
Transaction Date
Account Number
Location
Transaction Amount (mostly a credit amount)
User ID
Mgr Id
Multiple Transaction amounts can be made to the account either by 1 user or
multiple users.
On one account, I processed $5000 credit and on the same account you
processed $2000 credit, all done during a month one period 11/1-11/30. My
query is Group by Sum of Transaction Amount where it is < - 999.99.
When the query is run, I don't get any results back because 2 different
user's processed an adjustment.
If the same person processed the $7000 credit, this account is showing up in
the results.
Regardless of how many people issued the credit, I want any credits that
total greater than or equal to -999.99 for each account and it is now coming
up.
Transaction Date
Account Number
Location
Transaction Amount (mostly a credit amount)
User ID
Mgr Id
Multiple Transaction amounts can be made to the account either by 1 user or
multiple users.
On one account, I processed $5000 credit and on the same account you
processed $2000 credit, all done during a month one period 11/1-11/30. My
query is Group by Sum of Transaction Amount where it is < - 999.99.
When the query is run, I don't get any results back because 2 different
user's processed an adjustment.
If the same person processed the $7000 credit, this account is showing up in
the results.
Regardless of how many people issued the credit, I want any credits that
total greater than or equal to -999.99 for each account and it is now coming
up.