I am very new to Access and have run into a problem. I have a table of customer names and addresses. Each name is broken down into 5 separate fields, title, first, middle, last and suffix. I am trying to create list of names using only the first, last and suffix. This will produce a list of names in one string and separate similar names such as Joe Smith, and Joe Smith Jr. My problem is I am unable to create an unique column or field with the data. I have a query built with only the names First, Last and Suffix but I have run into a wall when trying to combine them into a useful list.
I am using Access 2013.
Thanks
Jim O
Bookmarks