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 cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

CALCULATED FIELD

Status
Not open for further replies.

LamarAt

Chemical
Joined
Apr 20, 2006
Messages
4
Location
US
I am trying to enter a formula to calculate a text field based on the Resource Name. What I want to do is test the resource name to see if it CONTAINS a certain string. The only options I see are =, <>, <, > . Below is an example of what I am using but it is not exact.

IIf([Resource Names]="ANLZ-1" Or [Resource Names]="E&I-1","GREG","JIM")

What I need is more like:

IIf([Resource Names]CONTAINS "ANLZ" Or [Resource Names]CONTAINS "E&I","GREG","JIM")

Any help would be appreciated!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top