title: Concatenate two columns in an Access table
body: <p>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.</p>
  
  <p>I would like to do this in the existing table and not in a new query.</p>
  
  <p>Thanks!</p>