concatenate multiple records - faq701-4233 help

[ossse]

I am trying to concatenate multiple records that have the same ID number (same goal as thread705-1197128). I have been using faq701-4233 as a guide however I don't think that I am calling the concatenate function correctly.

ID number field: 'taskCauseTaskID'
Field to concatenate: 'taskCauseFailureCause'
Table: 'TaskCauses'

here is my code, thanks in advance:

Sub Conc()

SELECT taskCauseTaskID, Concatenate ("SELECT taskCauseFailureCause FROM TaskCauses WHERE taskCauseTaskID =" & [taskCauseTaskID])

End Sub

 

[PHV]

You wrote SQL code in a VBA procedure ???

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886