Thread: Access question
View Single Post
 
Old 06-06-2005, 08:44 AM
Matrix's Avatar
Matrix Matrix is offline Windows 10 Office 2010
Admin
 
Join Date: Jan 2005
Posts: 417
Matrix is on a distinguished road
Default

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
Reply With Quote