I am populating an Excel 2007 spreadsheet with data from a union query in Access 2007. The first and last names, being different value fields, end up on different rows in the spreadsheet. How would I concatenate them into a single cell? I want them in the order of Last name, First name. Sample spreadsheet attached: EmployeeSkills.xlsx
The original query also includes a reference to the User_ID_fk, which is a concatenation of the first and last names, but unfortunately, the output is just the User_ID, the primary key. The original query is quniClassAndIndividual, if that can be modified to output the name to the spreadsheet as already concatenated. In other words, I'm open to a solution that works, regardless of the process, to concatenate the first and last names in the spreadsheet. Sample database attached: SampleSkills.accdb.