Good Morning All
i have a Table
Code:=================== DESCR CYCLE =================== Rendle C | 5 | Reid M Prof | 9 | Randall S Ms | 3 | Reid M Prof | 3 | Rendall G Mr | 3 | Rendle C | 3 | Rendall G Mr | 2 | ===================
Now as you can see "Rendle C" and "Rendall G Mr" appears Twice, now i want append the cyle field if the descr appears twice, the above list should now look like this
How can i do this in SQlCode:=================== DESCR CYCLE =================== Rendle C | 5 3 | Reid M Prof | 9 3 | Rendall G Mr | 3 2 | ===================
Thank you




Reply With Quote