I am trying to combine several columns from one table: The First Name, Last Name, Middle Name, City, State. I want to Combine the first, last, and middle names and then have a varying amount of spaces between it and the city and state. All of these will be combined into one column and displayed in a listbox. For Example: Problem: John Smith Los Angeles, CA Johnathan Smith Los Angeles, CA Solution: HOW! John Smith Los Angeles, CA Johnathan Smith Los Angeles, CA