Problems with the labeling of elements

Discussion created by drunken84 on Jul 28, 2010
Latest reply on Jul 31, 2010 by rfairhur24

I want to label polygons in a shapefile (to indicate the owners of particular properties). The data is stored in the attribute table. The two columns I have to work with are called "name" and 'firstname'. I used the following expression: [NAME] & ", " & [FIRSTNAME]. By using this, I end up with labels that look like this: "Smith, John". This is fine, but I've got the problem that there are also some companies who own land in the area. The company name is stored in the column "name" and there is no data in the column "surname", which means that in this case, I end up with a label that looks like this: "CompanyXYZ, ". How do I get rid of comma after the companie's name?


With best regards - Phil