Microsoft Access Table / Query Export

[bdavis6290]

I have 2 tables' tblRHM and tblRHM1. tblRHM has suploc, penloc, and RHM. tblRHM1 has RHM1, suploc, penloc, fname, lname, mname, dob, address, b1, b2, b3, and uniqueID . I also have a template I would like to use. The template has fname, lname, mname, dob, address, b1, b2, b3, and uniqueID. I would like to export fname, lname, mname, dob, address, b1, b2, b3, and uniqueID from tblRHM1 to my template. In tblRHM1 each individual is part of a RHM and I would like to export each group of RHMs into a separate spreadsheet (template). tblRHM is more of a crosswalk.

[twinnyfo]

bdavis6290,

I am not sure i understand what you are asking or trying to do. It looks like you have a lot of duplicated data, and are trying to duplicate it even more? Is your "template" also a Table?

Your request is not very clear.