Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by PortalMelt
-
conditional text content
Solved this myself with some help from another site. For the record, here is the code: =IIf([Before OH]>0 And [PROFIT]<0,"OH",IIf([Before OH]<0 And [PROFIT]<0,"COST",""))- PortalMelt
- Post #2
- Forum: Microsoft: Access Reports
-
conditional text content
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 "OH", ELSE DISPLAY " " and then this one: IF (Before OH <...- PortalMelt
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
