hi,
thank you for reply,and help
it works.
thanks so much.

best regards.
m.qasem
>>hi all,
>>i need help to divide my table to 12 tables as month12004,month22004....to 122004. where field(month=1 , 2 , ...12)
>>my table name is combined2004 and i have field month have 1,2,3....12
>>
>>thanks.
>

>FOR p_count = 1 TO 12
>    file_name = "month"+ALLTRIM(STR(p_count))+"2004"
>    SELECT * FROM combined2004 WHERE month = p_count INTO TABLE (file_Name)
>NEXT
>CLOSE ALL
>