Part of your problem is 'myTable' is the id for all three tables. You should set a 'RecCount=0' just before the 'Do While' and add a counter (i.e. - RecCount = RecCount + 1) right before the 'Loop'...