What makes this difficult is if it's the second or third time looping through, I'd like the data to update to different fields. For example - tblOne has the following fields: nonTermID, company, employee tblTwo has: hoursID, nonTermID, function, date, paycode tblThree has : nonTermID, company, employee, function1, Date1, payCode1, function2, date2, payCode2, function3, date3, paycode3. tblOne is joined to tblTwo on nonTermID. There is only one record in tblOne, and there can be multiple records