locked
Combine multiple rows result into a single field in OLEDB Access RRS feed

  • Question

  • User1538445636 posted

    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

    Sunday, March 10, 2013 1:03 PM

All replies

  • User-1360095595 posted

    Google/Bing: for xml path

    Sunday, March 10, 2013 4:35 PM