Simple SQL statement

[viperstingray]

Just wondering if this is doable. I have the following statement in a text box and would like to duplicate something like it. THIS IS WHAT I HAVE:
=Count(IIf([Measure Approved]="YES",0))

I NEED the other statement in another text box to do the following. Sum up the measure cost If MEASURE APPROVED = "YES". What would that statement be. I tried many many different variations.

thanks.

 

[Rich]

Sum(Iif([MEASURE APPROVED],[measure cost],0)

 

[viperstingray]

thanks you very much...YOU ROCK!