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