Access one to many query output so primary field doesn't repeat w/each

[Louise99]

I tried to search tek-tips for 'one-to-many' queries but couldn't find anything. I hope this isn't a really stupid question. I just can't figure it out

I'm trying to match the numbers of consultants per service date with a table that has the service date's code as primary key. There can be more than one consultant used for each service date. I need to know if it is possible to create a query where I match the service date codes as one to many and result showing all consultants for the record in just one output record.

I hope that makes sense . . . Here is what I have:

Service Code Consultant
123 AA
123 AB
124 AA
125 AB

I would like
Service Code Consultant1 Consultant2
123 AA AB

Thanks!

 

[fneily]

Well, if you searched the Office forum, you're probably right. There's seven Access forums. This should be posted in Microsoft: Access Queries and JET SQL.
This has been asked so many times that there's a FAQ on it:
How to concatenate multiple child records into a single value
faq701-4233