Hi,
Please have a look at the attached sample db. Initially I thought you wanted them side by side (like in the qryProf_Surg_Unique query) but now I see you actually wanted an union query. Please have a look at the two union queries (qryProf_Surgical_Union and qryProf_Surgical_Union_All), they should give you what you need (the difference is the use of UNION in the first one and UNION ALL in the second that preserves the duplicates).

Cheers,
VladDatabase1.accdb