Sum() certain fields

[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

 

[Duane Hookom]

=Sum(Abs([strFeeType]<>"C") * [curFeeAmt])

 

[Guest]

Thanks, Duane: it worked! I was just starting to think it could not be done.
ck

=Sum(Abs([strFeeType]<>"C") * [curFeeAmt])

--
Duane Hookom
MS Access MVP

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

 

[Guest]

nice, solved my problem too

=Sum(Abs([strFeeType]<>"C") * [curFeeAmt])

--
Duane Hookom
MS Access MVP

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