Commas in VB Editor Select Statement

[irunergoiam]

I'm trying to concatenate a name so it is Last name, First Name using the following:
SELECT 1STARTRequestLog.LastName & ", " & 1STARTRequestLog.FirstName AS [LNameFName]

Of course, it doesn't like the comma between the quotes: & ", " &. My question is how to get around that???

Thanks much for any gentle nudges any of you out there might provide. Or, I may just need to be hit over the head with it, too. Either way...

 

[pbaldy]

How do you mean it doesn't like it? It should work fine. I just tested this and it worked as expected:

SELECT [ConLastName] & ", " & [ConFirstName] AS FullName
FROM tblContactDetails