Kenn Omisol Kenn Omisol - 1 year ago 126 Question


I just started using ms access on my database and my problem now is how to appear my lastname and firstname as Name

CONCAT(Surname, ', ', Firstname) as Name - this is my mysql code, can someone convert this in access database? How can I make it appear as Name using access database coz it seems concat is not supported in ms access.

Answer Source

There's no CONCAT() function in MS Access. You should just use the string concatenation operator which is ampersand:

SELECT (Surname & ' ' & Firstname) AS FullName