combine multiple records

delb

New member
Local time
Today, 14:21
Joined
Dec 18, 2008
Messages
2
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
 
Thanks very much
 

Users who are viewing this thread

Back
Top Bottom