lizardcute83

not repeating label and display all data ini 1 line

Discussion created by lizardcute83 on Mar 27, 2012
Latest reply on May 1, 2012 by maotseduck
i'm trying to label my polygon like this.
NO CASE :4321,1234,5423
ADDRESS : MY ADDRESS

my problem is how to display all "NO_CASE" in 1 line and remove duplicate address..
if i do like this:
  FindLabel =""NO CASE :" &[NO_CASE]& vbnewLine & ADDRESS : "&[ADD_3]
my result :
NO CASE :4321
ADDRESS : MY ADDRESS
NO CASE :1234
ADDRESS:MY ADDRESS

PLZ HELP ME

Outcomes