Field Field Name Type Width Dec Index Collate Nulls Next Step
1 ID1 Numeric 3 No
2 ID Numeric 2 No
3 NAM Character 10 No
4 Y2009 Numeric 15 3 No
5 Y2010 Numeric 15 3 No
6 PER1 Numeric 15 3 No
7 TY2009 Numeric 15 3 No
8 TY2010 Numeric 15 3 No
9 TPER Numeric 15 3 No
10 FLG Numeric 2 No
** Total ** 108
>>thank you,
>>
>>how i can sent the table it is small table
>>
>>>What is the exact structure of the NewTest table? In other words, in addition to ID1 (which is month) what is the field that links records for each month? In my samples I was adding recno(), but there should be a better field we can use.
>>>
>
>Can you just post its structure? List structure to text.txt and post here the content of text.txt