Using Left Joins in recordset
Thanks for your reply, I went over everything with a fine tooth comb. I removed all but one recordset and then updated it to include the Left Joins. It is much tidier, but unfortunately it is still not looping through all the records. It is just reproducing the first record every time. I have attached the updated files so you can see the changes that I have made.
I did test it without the left joins altogether but it was still doing the same thing