Kenn Omisol Kenn Omisol - 10 months ago 116 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.


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

SELECT (Surname & ' ' & Firstname) AS FullName