Greetings @pbaldy helped me out with syntax in a diff thread on here, but that was just for the SQL - I am now having issues converting it to VBA. This is my Query SQL
Code:
SELECT Table1.empID, ConcatRelated('saleItem','[Table1]',"empID='" & [empID] & "'") AS Item
FROM Table1
GROUP BY Table1.empID;
And this is the VBA syntax I have tried...what is the proper way to utilize this in VBA?
Code:
DoCmd.RunSQL ("SELECT Table1.empID, ConcatRelated('saleItem','[Table1]','empID= ' & Chr(34) & [empID] & Chr(34) & ') AS Item Into Hopscotch FROM Table1 GROUP BY Table1.empID;")