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.