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
 
M

Marshall Barton

Sure, just use the same table name in both places.

OTOH, if you have a one to many relationship in a single
table, you may not have a properly normalized table
structure.
 

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
Appending records based on a query and user data from a form 0
Need help sorting a self join query 4
Concatenate values of one field from multiple records in query 2
Show records even with NULL data? WHERE...IN? 4
How do I export/save a shhet where some of the cells have multiple line values 1

Top