Tariq,
I think that the others give 'wrong' advices. You need a cross-tab resultset. Search for 'cross-tab' in the vfp-help.
>Dear Experts
>
>SELECT FDATE,GNO AS PARTY;
>FROM WEIGHTS;
>WHERE FDATE=THIS.VALUE ;
>ORDER BY PCODE;
>GROUP BY PCODE;
>INTO cursor fix
>
>
>The select statement generate folloiwng SQL Results
>
>25-09-2006------2
>25-09-2006------5
>25-09-2006------6
>25-09-2006------8
>25-09-2006------7
>
>But I want to get following result
>
>25-09-2006------2,5,6,7,8
>
>Please help
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
