How do I bring a filed from multiple records and join them tog
in [Queries]
|
Prev: How to calculate average for current quarter?
Next: Why does this query ask for the start date and end date twice?
From: Dave on 14 Apr 2010 15:14 This uses 2 tables, is it possible to use the function with a single table "Marshall Barton" wrote: > Dave wrote: > > >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 > > > Try using a function like the one at > http://www.rogersaccesslibrary.com/forum/generic-function-to-concatenate-child-records_topic16&SID=453fabc6-b3z9-34z6zb14-a78f832z-19z89a2c.html > > -- > Marsh > MVP [MS Access] > . >
From: Marshall Barton on 14 Apr 2010 18:54
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. -- Marsh MVP [MS Access] Dave wrote: >This uses 2 tables, is it possible to use the function with a single table >"Marshall Barton" wrote: >> Dave wrote: >> >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 >> >> >> Try using a function like the one at >> http://www.rogersaccesslibrary.com/forum/generic-function-to-concatenate-child-records_topic16&SID=453fabc6-b3z9-34z6zb14-a78f832z-19z89a2c.html >> |