Labeling a feature with one attribute field based on the attributes of another field

489
2
Jump to solution
06-03-2014 11:08 AM
ScottLouque
New Contributor III
This may be easy.

I am trying to label streets with values from one attribute field but want to exclude the label from those features where [Owner] = 'Multi'. How can I do this? It seems like something I've done before but can't remember.

Thanks.
Tags (2)
0 Kudos
1 Solution

Accepted Solutions
Zeke
by
Regular Contributor III
In the Labels tab, click the Method dropdown and select 'Define classes of features and label each class differently'. Click the SQL Query button and enter [Owner]<>  'Multi'. Make sure to check the box for Label features in this class and you're done.

View solution in original post

0 Kudos
2 Replies
Zeke
by
Regular Contributor III
In the Labels tab, click the Method dropdown and select 'Define classes of features and label each class differently'. Click the SQL Query button and enter [Owner]<>  'Multi'. Make sure to check the box for Label features in this class and you're done.
0 Kudos
ScottLouque
New Contributor III
Thanks for the reply.
I already have my streets broken up into classes and can't use the SQL Query tool to write a statement to do this.

However,

I wrote a function in the Expressions dialog box.

Function FindLabel ([ST_Label], [Owner])
  If  ([OWNER] <> Multi) then
FindLabel = [ST_LABEL]
End If
End Function

This seemed to do what I want. 

Thanks for the reply!
0 Kudos