This would be very easy to do using some VBA code (a "module" in Access, which you can then run from a "macro"). Basically, query the two tables into Recordsets, and loop through them.

Learn how to master Microsoft Access with this comprehensive guide to database management, from core features to advanced tools and best ...