Thank you for the quick response. I am relatively new to Access so I'm not to sure exactly what you mean. Both tables (GuestInfo and OldGuestInfo) are setup with the same fields which are as follows:
Passport, Nationality, Name, Date Entered, Date Paid, Monies Paid, Date Paid To, Accumlalate...