Join 2 fields into a 3rd field

[N1947gm]

I have a table with LastName and Firstname fields. I would like to join them into a FullName field.
LastName FirstName FullName
Smith John Smith, John

[robleyd]

Why? You would be storing redundant data; you can do this at reporting time in your query to display the information.