Kenn Omisol Kenn Omisol - 3 months ago 21
Vb.net Question

VB.NET MS ACCESS

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

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

SELECT (Surname & ' ' & Firstname) AS FullName