Concatenate two columns in an Access table

Question

very simple one. I have got two fields in a table called [First Name] and [Last Name]. I would like to add a new column that is just a combination of [First Name] and [Last Name] - is there a way to do this in Access? I know this can be done in Excel using the Concatenate function.

I would like to do this in the existing table and not in a new query.

Thanks!

Answer 1

As @paxty says, do not do this. You have a simple answer in Access that is not available in Excel, and that is a query. You can base any output that requires that the two names be concatenated on a query.

SELECT FirstName & " " & LastName FROM MyTable