Hi.
I am trying to combine records that have the same task number but different tools, they are in the same table. ie
ID, Tool
1 Spanner
1 Hammer
2 Wrench
2 Hammer
I would like to get for ID 1
Spanner, Hammer
and ID 2
Wrench,Hammer
I have tried using a function within a query...