RESOLVED: concatenate sql String

[Suidae]

I'm using the following SQL to populate a temporary table. Everything works fine but I would like to have a comma between EmployeeLast and EmployeeFirst. Everything I've tried splits the name into two fields instead of one.

sql = "SELECT tblReportData.EmployeeID AS Employee, Count(tblReportData.EmployeeID) AS Reports, [EmployeeLast]&[Employeefirst] AS Name INTO tbltmpReport "
sql = sql & "FROM tblEmployee INNER JOIN tblReportData ON tblEmployee.EmployeeID = tblReportData.EmployeeID "
sql = sql & "WHERE (((tblReportData.DateOpened) Between #" & StartDate & "# And #" & StopDate & "#) AND ((tblReportData.ParentID)=1)) "
sql = sql & "GROUP BY tblReportData.EmployeeID, [EmployeeLast]&[Employeefirst];"

Can anyone give me a clue?

I've have tried and a couple of other combos.

[EmployeeLast]" & " , " & " "[Employeefirst]