>all records where field(month=1) insert to table(ex.. month12004),
if month<>1
creat new table month22004 ...etc...,
FOR I=1 TO 12
SET FILTER TO month=I
GO TOP
IF !EOF()
COPY TO ("Month"+ALLT(STR(I))+"2004") FOR month=I
ENDFOR
ENDFOR
There's never enough time to do it right, but always enough time to do it again.
