D
Dion
I have a report where Bank X will give back a provisional
credit toward a credit card when a customer disputes a
transaction. Bank X also charges $1.00 for a
miscellaneous fee. In the report that was designed as the
letter to be sent to the customer stating the credit,
there is a field called AMOUNT. there are usually
multiple transaction amounts in the letter. I am trying
to get the correct expression to put into the field
(textbox) where it will add the $1.00. I have tried sum
([AMOUNT]+1) but get a sum of all tranactions in the
AMOUNT field. I want to add $1.00 to each individual
transaction. Any ideas on what expression I could/should
use?
credit toward a credit card when a customer disputes a
transaction. Bank X also charges $1.00 for a
miscellaneous fee. In the report that was designed as the
letter to be sent to the customer stating the credit,
there is a field called AMOUNT. there are usually
multiple transaction amounts in the letter. I am trying
to get the correct expression to put into the field
(textbox) where it will add the $1.00. I have tried sum
([AMOUNT]+1) but get a sum of all tranactions in the
AMOUNT field. I want to add $1.00 to each individual
transaction. Any ideas on what expression I could/should
use?