I have a few questions. First off, I have a recordset where I am selecting the columns name_pre, name_first and name_last. I want to have the name displayed as Mr. John Smith, just combining all 3 columns.
The second portion where I am running into problems is displaying the aforementioned Join. Basically, I am going to have a list and detail page, where a person can select a user's name from a menu that uses the recordset. The only option I have is to pick name_pre, first or last. How can I set it up so that a person's entire name will be displayed as Mr. John Smith?
Thanks in advance.