Need your help to get the single entry in a row with multiple tasks.

Hi Team, I am having an unique numbers in my table, after running the query getting multiple entries for those unique no's tasks. Need your help to get the single entry in a row with multiple tasks. please refer the below given e.g. Current Extract in a query Unique No. Tasks 1001 excel 1001 word 1003 powerpoint 1003 word 1004 access 1004 sql 1005 sql 1005 word Need an extract as per the below given table Unique No. Tasks 1001 excel,word 1003 powerpoint,word 1004 access,sql 1005 sql,word

Hi, Sorry, but I can't think of a way to do what you want with a standard SELECT statement. Your database may support non-standard clauses to do it, though, so I suggest you ask in a forum dedicated to your database. Best Regards, Hans