Hi, I am trying to write a loop that runs about 70,000 times. I know this is big, and I expect it to take a while. But for some reason, my Access has trouble running loops bigger than 9 iterations, I get a message that says "subscript out of range" and the loop truncates at 9. Right now I am using a do...while loop. Any ideas as to why I am prohibited from running large loops, or how I can fix this? Thank you.