using LIKE inside an IIF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello Group,

is there any rule that would keep me from using LIKE inside of an IIF? Here
is what I am doing:

Expr1: IIf([find DCIS]!Experience="like *DCIS*","data was present","data was
not present")

The field Experience is tested for the text DCIS. I can do this in a select
query all day long. Now I need to place the result of the test in a field: i
just need to place the text data was present or data was not present.
Because I have place the test into an IIF, it does not seem to work anymore.

Rich
 
Rich said:
Hello Group,

is there any rule that would keep me from using LIKE inside of an
IIF? Here is what I am doing:

Expr1: IIf([find DCIS]!Experience="like *DCIS*","data was
present","data was not present")

The field Experience is tested for the text DCIS. I can do this in a
select query all day long. Now I need to place the result of the
test in a field: i just need to place the text data was present or
data was not present. Because I have place the test into an IIF, it
does not seem to work anymore.

Rich
Click to expand...

Get rid of the = and get the Like on the outside of the quotes...

Expr1: IIf([find DCIS]!Experience like "*DCIS*","data was present","data was not
present")
 
Hello Rick,

that was so simple, why didn't i think of that...thanks rick!

Rich

Rick Brandt said:
Rich said:
Hello Group,

is there any rule that would keep me from using LIKE inside of an
IIF? Here is what I am doing:

Expr1: IIf([find DCIS]!Experience="like *DCIS*","data was
present","data was not present")

The field Experience is tested for the text DCIS. I can do this in a
select query all day long. Now I need to place the result of the
test in a field: i just need to place the text data was present or
data was not present. Because I have place the test into an IIF, it
does not seem to work anymore.

Rich
Click to expand...

Get rid of the = and get the Like on the outside of the quotes...

Expr1: IIf([find DCIS]!Experience like "*DCIS*","data was present","data was not
present")
Click to expand...
 
Back
Top