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.

I have a column in my database which was pulled from an AS/400 database and the date is in the form of "Friday,December 10th,2003" which is unreadable to Access and Excel. I have figured out that ...

Learn how to create a Comments Table, add database objects, etc, using the Application Parts feature in Microsoft Access.