customize bars by groups or names

[Tom]

I have recurring tasks and groups of task that I would like to define custom
bar styles for (to simplify viewing). What is the easiest way to do customize
groups of tasks instead of changing each individual bar?

Post titled: formatting summary bars by level, shows how flags can used to
simplify formatting summary bars by level. What is the syntax for matching
part of name? Example, I tried the following but did not work.
IIf([name]="Meeting*",True,False) Maybe the question is really, how do I
indicate wild characters?

Thanks in advance,

Tom

 

[JackD]

Use the instr function

Instr
Returns a Variant (Long) specifying the position of the first occurrence of
one string within another.
Syntax
Instr( [start, ]string1, string2[, compare] )
start Optional; numeric expression that sets the starting position for
each search. If omitted, search begins at the first character position. If
start contains Null, an error occurs. The start argument is required if
compare is specified.
string1 Required; string expression being searched.
string2 Required; string expression sought.
compare Optional; specifies the type of string comparison. If compare is
Null, an error occurs. If compare is omitted, the Optioncompare setting
determines the type of comparison.


For your formula it would be:

iif(instr([Name],"Meeting")>0,True, False)

 

[Tom]

thanks. In addition to your solution, I discovered that this also works:

IIf([Name] Like "Meeting*",True,False)

I use the like function alot in MS Access. The asterik works as a
wildcard. Again, thanks for your help.

Tom

Use the instr function

Instr
Returns a Variant (Long) specifying the position of the first occurrence of
one string within another.
Syntax
Instr( [start, ]string1, string2[, compare] )
start Optional; numeric expression that sets the starting position for
each search. If omitted, search begins at the first character position. If
start contains Null, an error occurs. The start argument is required if
compare is specified.
string1 Required; string expression being searched.
string2 Required; string expression sought.
compare Optional; specifies the type of string comparison. If compare is
Null, an error occurs. If compare is omitted, the Optioncompare setting
determines the type of comparison.


For your formula it would be:

iif(instr([Name],"Meeting")>0,True, False)

--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..

I have recurring tasks and groups of task that I would like to define custom
bar styles for (to simplify viewing). What is the easiest way to do customize
groups of tasks instead of changing each individual bar?

Post titled: formatting summary bars by level, shows how flags can used to
simplify formatting summary bars by level. What is the syntax for matching
part of name? Example, I tried the following but did not work.
IIf([name]="Meeting*",True,False) Maybe the question is really, how do I
indicate wild characters?

Thanks in advance,

Tom

 

[JackD]

My problem with this is that I don't like meeting*

--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..

thanks. In addition to your solution, I discovered that this also works:

IIf([Name] Like "Meeting*",True,False)

I use the like function alot in MS Access. The asterik works as a
wildcard. Again, thanks for your help.

Tom

Use the instr function

Instr
Returns a Variant (Long) specifying the position of the first occurrence of
one string within another.
Syntax
Instr( [start, ]string1, string2[, compare] )
start Optional; numeric expression that sets the starting position for
each search. If omitted, search begins at the first character position. If
start contains Null, an error occurs. The start argument is required if
compare is specified.
string1 Required; string expression being searched.
string2 Required; string expression sought.
compare Optional; specifies the type of string comparison. If compare is
Null, an error occurs. If compare is omitted, the Optioncompare setting
determines the type of comparison.


For your formula it would be:

iif(instr([Name],"Meeting")>0,True, False)

--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..

I have recurring tasks and groups of task that I would like to define custom
bar styles for (to simplify viewing). What is the easiest way to do customize
groups of tasks instead of changing each individual bar?

Post titled: formatting summary bars by level, shows how flags can used to
simplify formatting summary bars by level. What is the syntax for matching
part of name? Example, I tried the following but did not work.
IIf([name]="Meeting*",True,False) Maybe the question is really, how do I
indicate wild characters?

Thanks in advance,

Tom

 

[Tom]

Haha, why not?

My problem with this is that I don't like meeting*

--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..

thanks. In addition to your solution, I discovered that this also works:

IIf([Name] Like "Meeting*",True,False)

I use the like function alot in MS Access. The asterik works as a
wildcard. Again, thanks for your help.

Tom

Use the instr function

Instr
Returns a Variant (Long) specifying the position of the first occurrence of
one string within another.
Syntax
Instr( [start, ]string1, string2[, compare] )
start Optional; numeric expression that sets the starting position for
each search. If omitted, search begins at the first character position. If
start contains Null, an error occurs. The start argument is required if
compare is specified.
string1 Required; string expression being searched.
string2 Required; string expression sought.
compare Optional; specifies the type of string comparison. If compare is
Null, an error occurs. If compare is omitted, the Optioncompare setting
determines the type of comparison.


For your formula it would be:

iif(instr([Name],"Meeting")>0,True, False)

--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..
I have recurring tasks and groups of task that I would like to define
custom
bar styles for (to simplify viewing). What is the easiest way to do
customize
groups of tasks instead of changing each individual bar?

Post titled: formatting summary bars by level, shows how flags can used to
simplify formatting summary bars by level. What is the syntax for matching
part of name? Example, I tried the following but did not work.
IIf([name]="Meeting*",True,False) Maybe the question is really, how do I
indicate wild characters?

Thanks in advance,

Tom