KDM913,
Try using the LEFT function on the full length name. Make sure that the field holding the concatenated name is long enough! You can also get the #NAME if the table does not have some of all of the fields being used. If something is not spelled correctly, that is like not having that...