>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
>>
You're welcome.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst