Thanks David,
that all seems to work now.
>Frank,
>
>>I've got two problems. The first is that the 3 memo fields in my table do not get included in the array when I "scatter to laAddRow". So this causes a problem with matching up the number of array elements and the number of fields.
>
>Add MEMO to the scatter
>
>>The second is I don't understand why you are checking the non-empty values from the 2nd field. Is it that you were assuming the first field is the key field? If so, that's not correct, the key field can be anywhere in the table.
>
>Yeah that was the assumption, starting at 2 just made the loop have one less iteration to make it some percentage faster. Go ahead and start the FOR loop with 1 it won't hurt the code.