Last post Mar 10, 2013 04:35 PM by MetalAsp.Net
Member
2 Points
18 Posts
Mar 10, 2013 01:03 PM|novatgirl|LINK
Please help me, what i need is very easy,i want to put the query result (rows) into a single field. Cannot use INNER JOIN because there are similar values.
tblSERVICES
user service
121 Tv
122 phone
121 phone
124 internet
121 internet
_____________________________________________________
SELECT service WHERE user = 121;
Output (3 rows):
Tv
Phone
Internet
______________________________________________
I need the follow result into a single field or temporary column so i can use it in a report.
Tv, Phone, Internet
All-Star
101931 Points
20703 Posts
Moderator
Mar 10, 2013 04:35 PM|MetalAsp.Net|LINK
Google/Bing: for xml path
Member
2 Points
18 Posts
Combine multiple rows result into a single field in OLEDB Access
Mar 10, 2013 01:03 PM|novatgirl|LINK
Please help me, what i need is very easy,i want to put the query result (rows) into a single field. Cannot use INNER JOIN because there are similar values.
tblSERVICES
user service
121 Tv
122 phone
121 phone
124 internet
121 internet
_____________________________________________________
SELECT service WHERE user = 121;
Output (3 rows):
Tv
Phone
Internet
______________________________________________
I need the follow result into a single field or temporary column so i can use it in a report.
Tv, Phone, Internet
All-Star
101931 Points
20703 Posts
Moderator
Re: Combine multiple rows result into a single field in OLEDB Access
Mar 10, 2013 04:35 PM|MetalAsp.Net|LINK
Google/Bing: for xml path