>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
_______________________________________________________________
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