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]

[BruceG]

Try using + instead of &:

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];"

[Suidae]

Thanks for your reply... The result is still
DoeJohn and I'm trying to have a result of
Doe, John

[Suidae]

Got it! Just in case anyone wants to know.

[EmployeeLast] & ', ' & [Employeefirst]