conditional text content

[PortalMelt]

I can't find how to do this.

(Note: I'm sure this syntax is all wrong, I don't know Access very much)
In my report I need to do something like :

IF (Before OH > 0) AND (([Before OH]+[OH Cost Calc])<0) DISPLAY &quot;OH&quot;, ELSE DISPLAY &quot; &quot;

and then this one:

IF (Before OH < 0) AND (([Before OH]+[OH Cost Calc])<0) DISPLAY &quot;COST&quot;, ELSE DISPLAY &quot; &quot;

How do I do this?

Thanks,
Jeff

 

[PortalMelt]

Solved this myself with some help from another site.

For the record, here is the code:

=IIf([Before OH]>0 And [PROFIT]<0,&quot;OH&quot;,IIf([Before OH]<0 And [PROFIT]<0,&quot;COST&quot;,&quot;&quot)