Sum() certain fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my report, I have a control that adds all the fees together. However, I do
not want to include a particular fee with the strFeeType = C. How do I string
all these together into the control? Right now, my control source is
=Sum([curFeeAmt]). Thanks.
ck
 
Thanks, Duane: it worked! I was just starting to think it could not be done.
ck

Duane Hookom said:
=Sum(Abs([strFeeType]<>"C") * [curFeeAmt])

--
Duane Hookom
MS Access MVP


CK said:
In my report, I have a control that adds all the fees together. However, I do
not want to include a particular fee with the strFeeType = C. How do I string
all these together into the control? Right now, my control source is
=Sum([curFeeAmt]). Thanks.
ck
Click to expand...
Click to expand...
 
nice, solved my problem too

Duane Hookom said:
=Sum(Abs([strFeeType]<>"C") * [curFeeAmt])

--
Duane Hookom
MS Access MVP


CK said:
In my report, I have a control that adds all the fees together. However, I do
not want to include a particular fee with the strFeeType = C. How do I string
all these together into the control? Right now, my control source is
=Sum([curFeeAmt]). Thanks.
ck
Click to expand...
Click to expand...
 
Back
Top