combine multiple records

[delb]

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, but end up with all the tools listed for each ID eg
ID 1
Spanner, Hammer, Wrench, Hammer
and ID 2
Spanner, Hammer, Wrench, Hammer

Any help would be great as I am a complete novice on access

 

[Mike375]

This a link to member KenHigg sample DBs. Check the 5th one down called Consolidate

http://www.access-programmers.co.uk/forums/showthread.php?t=99777

This might be what you are looking for.

As you will see the table medications has lots of recrods that appear to be like. Open Form1 and click runroutine and then check the table tempmedications

 

[delb]

Thanks very much

 

[Mike375]

Thanks very much

Ken is the man to thank