Combine multiple rows result into a single field in OLEDB Access RSS

• • Reply
  novatgirl

  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

• • Reply
  MetalAsp.Net

  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

  C# <--> VB.Net  |  jQuery Widgets