hi to all, can you please help me on sum() functions.
i have a field in a table called AmtFee and AmtID with the value of...

AmtID AmtFee
1 1000
2 2500
2 2500
1 1000

i want to put in a text box the sum of AmtFee where AmtID=1
i'm having a hard time to figure this out in IIf condition.
does anybody know what is the better approach on this?
i tried this kind of expressions but it didn't work.
=Sum(IIf(Fields!AmtID.Value=1,Fields!AmtFee.Value, 0))
Tnx in advance.

Try this

SUM(IIF(Fields!AmtID.Value=1,Fields!AmtFee.Value,F ields!AmtFee.Value*0)