I have a glitch in a script that I cant figure out- hopefully the experts on this board have a clue to what is going on..
My script loops through a found set of records and sets the value of 22 separate fields in Table A to the same value in Table B. It then creates an Excel sheet with all the values in Table B.
All works fine, except 1 of the fields in not setting properly. Set field might work on 3 of the 4 rows, none of the rows, 1 out of 4, etc. There doesn't seem to be any rhyme or reason to it. See screen shot below, with the problem steps highlighted.
Any help would be greatly appreciated!!