What's wrong with this IIf expression

[Guest]

I want the expression to show "BI" from all values start from BI**** BUt it
doesnt work. I am using * as wildcare:

IIf([Subject]=BI*, "BI") and this too: IIf([Subject]=*F1*, "F1")

Is BI* valid value? (in Subject field I have BIF1A, BIF3B & etc)

What is worng ?
Pls help. Thank you

 

[Guest]

IIf(expr, truepart, falsepart)

You need to put in a falsepart if it isn't BI*. Then there is the problem of
the wildcard. Try this instead.

IIf(Left([Subject],2)= "BI", "BI", [Subject])

 

[Marshall Barton]

I want the expression to show "BI" from all values start from BI**** BUt it
doesnt work. I am using * as wildcare:

IIf([Subject]=BI*, "BI") and this too: IIf([Subject]=*F1*, "F1")

Is BI* valid value? (in Subject field I have BIF1A, BIF3B & etc)

You must use the Like operator with wildcards. Also, the
pattern must be enclosed in quotes:

IIf([Subject] Like "BI*", "BI")

 

[Guest]

Thanks Jerry for the help

IIf(expr, truepart, falsepart)

You need to put in a falsepart if it isn't BI*. Then there is the problem of
the wildcard. Try this instead.

IIf(Left([Subject],2)= "BI", "BI", [Subject])
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I want the expression to show "BI" from all values start from BI**** BUt it
doesnt work. I am using * as wildcare:

IIf([Subject]=BI*, "BI") and this too: IIf([Subject]=*F1*, "F1")

Is BI* valid value? (in Subject field I have BIF1A, BIF3B & etc)

What is worng ?
Pls help. Thank you

 

[Guest]

Thanks Barton for the help

I want the expression to show "BI" from all values start from BI**** BUt it
doesnt work. I am using * as wildcare:

IIf([Subject]=BI*, "BI") and this too: IIf([Subject]=*F1*, "F1")

Is BI* valid value? (in Subject field I have BIF1A, BIF3B & etc)

You must use the Like operator with wildcards. Also, the
pattern must be enclosed in quotes:

IIf([Subject] Like "BI*", "BI")