Search results

Not the correct number of arguments. IIf(me![Moisture Exceed] >0)then([Quantity] * [Moisture Exceed] /100 * [Unit Price]) or =IIf(me![Moisture Exceed] >0)then/100 * {Quantity]*[Unit Price]) I have placed these both in the control source of the text box. Is it not suppose to go there? And If...

calc IIF(Moisture Exceedance>0) I have no clue here what I am doing. Beginners! If I want to display only the values that are >0 what would be the expression? Then would I be able to use that in my nest calculation for a penalty fee on the number displayed?

I have a text box with a calculation. When the result is >0 - I want to use it in another calculation. If not then ignore it. How can I do this? Would this be a IF/Then expression and how do you use it and where?

Thanks that seems to work!! Your a life saver.

Reply Did not work. All values change color. Is it because the calulation is there?

calculated fields with conditional formatting When I tried the conditional fromatting on the calculated field it did not matter what the value was and it applied the format. For instance I have a difference calculation. It can be negative. zer, or positive value. I would like the positve value...

I will try those Thanks for the info. I will try those.

I have calculated fields on a form. Can these be saved to the query or table? I would like to list these calculated fields (from the form) onto a report. Is it possible to do that? And also is there a way to only show positive values from a calculated field (others would be blank) or change...