Calculation question

[jcarson]

Is there a way to do an IF function that says if text field X CONTAINS the phrase "blah blah blah", then value Y?

Thanks,

Jeff

[QuinTech]

Sure...

Case ( 

  PatternCount ( 

    field X , 

    "blah blah blah" 

  ) , 

   "value Y" 

) 

You could use the If function, but Case is quicker.

J

[jcarson]

Thanks, exactly what I was looking for.

Jeff