March 21, 200421 yr I have a repeating field with 12 values. Does anyone have a simple way to delete all the values in a repeating field in a found set of records. I was hoping a function to move to the next repetition in a field was available. But I can't find one. My solution currently contains 12 steps i.e. using the Replace["field rep 1",value] Version: v5.x Platform: Windows XP
March 22, 200421 yr Here's one simple method using two loops, one to loop through the records and one to loop through the repetitions. It only requires that you ensure the Tab order flows consecutively through the repetitions and that at least one other field is on the layout. clearreps.zip
March 22, 200421 yr Another really neat technique is on http://www.datatude.net/ in the Tips and Download section. The title is "Clear All Repetitions"
Create an account or sign in to comment