View Single Post
  #2 (permalink)  
Old September 30th, 2004, 08:37 AM
pgtips pgtips is offline
Friend of Wrox
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post

After the first pass through the inner loop you need to set rec1 back to the beginning (rec1.MoveFirst), otherwise on the second pass through the outer loop the "Do Until rec1.EOF" bit does nothing because rec1 is still at EOF from the previous pass.