conditional formatting or control source?

[Rujahin]

I have a report with 5 fields. [txtRow],[ txtTotal],[ txtFail],[txtPercent], [txtReplace].


What I want to happen is for the [txtReplace] field to show the value of [txtTotal] when [txtPercent] is 30 or above. And when [txtPercent] is 29 or under, [txtReplace] should show Zero. The control source for [txtPercent] is =[txtFail]/[txtTotal]. I’ve tried various forms of IIf statements in the control source for [txtReplace] and in the conditional formatting expression box. I just can’t seem to make it work. Any help would be appreciated.

[pbaldy]

Try

=IIf( [txtPercent] >= 0.30, [txtTotal], 0)

[Rujahin]

That's it. thanks much. I just didn't have the freakin decimal point in there.

[pbaldy]

Happy to help. You're not the first one to forget about that.