#1
|
|||
|
|||
Access question
I am looking for a querrie that would take multiple records and populate a single field. For example.
Name Friends Dave Bob Dave Tom Sally Kim Sally Brenda The querrie would return Name Friends Dave Bob, Tom Sally Kim, Brenda P.S. I don't know visual basic. |
#2
|
|||
|
|||
Hi Ayres, welcome to the forum.
About your maiden post, could you please be more specific? What language/database exactly do you want to achieve this? Would SQL Select statement do? |
#3
|
|||
|
|||
I am using Access 2003. The report I am creating uses ODBC drivers to pull information directly from our company database. All my querries are created in design view.
|
#4
|
||||
|
||||
Normally I use a simple query first, then combine the queried results with programming, when the name in the next record is the same with current record, group them into one object (string, etc. according to your code), if they are different, finish current record and start a new one.
SQL query: select Name, Friends from table_name order by Name |
#5
|
||||
|
||||
I don't think it's possible unless you have fixed number of friends for each person, like two.
|
#6
|
|||
|
|||
Interesting, let me check and let you know.
|
#7
|
|||
|
|||
Had give it a try but don't think it is possible unless you had fixed number of friend. Easy solution will be like hurricane suggest used programming to loop thru it.
If you are using PL/SQL (Oracle) then you can create a function which will return concatenated friends name as a string and used it in your query. Edited--- This SQL will return what you want but fixed friends SELECT DISTINCT t.name, f1.friend & ', ' & f2.friend AS friends FROM tb t, tb f1, tb f2 WHERE t.name = f1.name AND tname = f2.name AND f1.friend < f2.friend; |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hiya, New guy here with a question. | twincamfxd | Outlook | 0 | 09-10-2006 08:50 PM |
Need help with this question... | lllDNYlll | Outlook | 0 | 05-04-2006 07:17 AM |
Categories question & replying with attachment question | glitzymama | Outlook | 0 | 03-15-2006 09:32 AM |
Dumb question | ExcelNewbie | Excel | 1 | 03-09-2006 04:45 PM |
Can Access access folders & sub-folders and dig out data? | nrg | Office | 4 | 06-20-2005 11:09 PM |