I'm sure it will do in time Kim.I am finding difficulty in seeing the relationships here. Maybe I'm wrong but I'm seeing 3 separte tables perhaps with the same structure.
One way with Access to merge the results of similar tables is to run a UNION query on the data.
Jon