How do I bring a filed from multiple records and join them togethe

D

Dave

I have a recordset that has a common identifier with comment information on
multiple lines. I want to create a query that diplays the multiple lines in
a single line. I will send this off into another table.

So...

ID Comment
123 Hello
123 Dave


would equal 123 Hello Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate the values from the same column in multiple records 5
Concatenating the same field from multiple records 16
returning multiple records on a single line 3
Concatenate values of one field from multiple records in query 2
Outlook Outlook 2013: How to print the task list so that it shows the notes on multiple lines if needed 0
How do I filter records with same identifier to pick the first on. 2
how to search & replace chr in multiple fields and records 1
How can I join two queries and avoid duplicate records? 4

Top