wildcard(*) in report conditional expression

[Guest]

I am attempting to use a wildcard(*) character in a conditional expression
and it is not recognized as the wildcard character. How do you properly
include a wildcard in the expression? This is the expression:

=IIF([TaskOutline] = *.1, "Planning", IIF([TaskOutline] = *.2, "Long Term
Target", "Activity"))

The report has an underlying query that includes the TaskOutline numbers.
The report includes two text boxes (1)TaskOutline, (2)Description. The
TaskOutline control is bound to the query field and the Description control
is unbounded.

I would like the Description text box to contain a string based on the value
of the TaskOutline number. 1|2|3 = Activity, 1.1|2.1|3.1 = Planned,
1.2|2.2|3.2 = Long Term Target

Any help will be very much appreciated.
Thanks.
MC

 

[David Seeto via AccessMonster.com]

Unforunately, when it comes to these expressions, there are no wildcards -
you can only look for exact matches. Having said that, though, you can use
functions to pull out the last part of the string to do exactly what you
want:
=IIF(Right([TaskOutline],2) = ".1", "Planning", IIF(Right([TaskOutline],2)
= ".2", "Long Term Target", "Activity"))

 

[Guest]

Thanks David. That worked perfectly!