G
Guest
hello,
Is there a way in query to provide two separate sum totals for something
like a three letter text.....For example, i have an invoices which has codes
for types of credits given per transaction
RSD transaction 345567888 $33.00
PBS transaction 456687900 $44.50
WIN transaction 345576777 $37.99
--These three letter text codes identify writeoffs (money never to be
recovered)
RBG transaction 675666778 $54.65
FTW transaction 987667899 $43.25
.....These three letter text codes identify rebills (money that can be
recovered)
Each one of these codes would represent a transaction in a invoice in
dollars so that is why i would want a separate sum total for credits given
for writeoffs or rebills to determine what amounts in dollars has been
totally written off and what hasnt.
Thanks
Is there a way in query to provide two separate sum totals for something
like a three letter text.....For example, i have an invoices which has codes
for types of credits given per transaction
RSD transaction 345567888 $33.00
PBS transaction 456687900 $44.50
WIN transaction 345576777 $37.99
--These three letter text codes identify writeoffs (money never to be
recovered)
RBG transaction 675666778 $54.65
FTW transaction 987667899 $43.25
.....These three letter text codes identify rebills (money that can be
recovered)
Each one of these codes would represent a transaction in a invoice in
dollars so that is why i would want a separate sum total for credits given
for writeoffs or rebills to determine what amounts in dollars has been
totally written off and what hasnt.
Thanks