wildcard(*) in report conditional expression

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

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
 
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"))
 
Back
Top