>Hi Rich
>
>I replaced it as you said:
>
>SELECT GETWORDNUM(Prog_long,1,",") , COUNT(*) AS Quant FROM reembolso GROUP BY prog_long where reembolso.date > DATE()-thisform.days.value INTO CURSOR crsReemb ORDER BY quant DESC
>
>But I got the error message "variable not found".
>

SELECT GETWORDNUM(Prog_long,1,",")  AS prog_long ,  COUNT(*) AS Quant;
  FROM reembolso;
  WHERE reembolso.date > DATE()-thisform.days.value;
  GROUP BY 1;
  ORDER BY quant DESC; 
  INTO CURSOR crsReemb

>It seems the command is not accepted in a line, or am I doing something wrong ?
>
>Moises
>
>
>>>I am using the code below to group results,but the problem is that some records have a comma which duplicates some results
>>>
>>>eg:
>>>
>>>Yellow
>>>blue
>>>blue,
>>>green
>>>red
>>>red,
>>>
>>>Is there a way to remove the comma only from the the result of the code below without removing the commas from the original table ?
>>>
>>>
>>>SELECT Prog_long , COUNT(*) AS Quant FROM reembolso GROUP BY prog_long where reembolso.date > DATE()-thisform.days.value INTO CURSOR crsReemb ORDER BY quant DESC
>>
>>Try......
>>

GETWORDNUM(myfield,1,",")