Is it possible to append a Union query?

Hi I have a union query to show missed checks, so the query highlights channels that were not checked over a 24 hour period separated into 3 shifts, (6am-2pm, 2pm-10pm, 10pm-6am). The report for these missing checks is emailed every morning after 6am, what I would like to see is all the missed checks over a 7 day period in a summary (report).

My thoughts were to maybe append the daily results into a table and create a report from there, but is this possible to do from the union query and how to do it?

I have added my SQL for the union:

SELECT "Early Shift" As Shift, ChannelName, StartTime,EndTime,"Cage Checks" AS Quality

FROM CageNotCheckedEarlyShift

UNION ALL

SELECT "Late Shift", ChannelName, StartTime,EndTime, "Cage Checks" AS Quality

FROM CageNotCheckedLateShift

UNION ALL

SELECT "Night Shift", ChannelName,StartTime,EndTime, "Cage Checks" AS Quality

FROM CageNotCheckedNightShift

UNION ALL

SELECT "Early Shift" As Shift, ChannelName, StartTime,EndTime,"Carton Checks" AS Quality

FROM CartonNotCheckedEarlyShift

UNION ALL

SELECT "Late Shift", ChannelName, StartTime,EndTime, "Carton Checks" AS Quality

FROM CartonNotCheckedLateShift

UNION ALL

SELECT "Night Shift", ChannelName,StartTime,EndTime, "Carton Checks" AS Quality

FROM CartonNotCheckedNightShift

UNION ALL

SELECT "Early Shift", ChannelName, StartTime,EndTime, "Cracks & Acid Checks" AS Quality

FROM CrackAcidNotCheckedEarlyShift

UNION ALL

SELECT "Late Shift", ChannelName, StartTime,EndTime, "Cracks & Acid Checks" AS Quality

FROM CrackAcidNotCheckedLateShift

UNION ALL

SELECT "Night Shift", ChannelName, StartTime,EndTime, "Cracks & Acid Checks" AS Quality

FROM CrackAcidNotCheckedNightShift

UNION ALL

SELECT "Early Shift", ChannelName, StartTime,EndTime, "Flow Wrap Checks" AS Quality

FROM FlowWrapNotCheckedEarlyShift

UNION ALL

SELECT "Late Shift", ChannelName, StartTime,EndTime, "Flow Wrap Checks" AS Quality

FROM FlowWrapNotCheckedLateShift

UNION ALL

SELECT "Night Shift", ChannelName, StartTime,EndTime, "Flow Wrap Checks" AS Quality

FROM FlowWrapNotCheckedNightShift

UNION ALL

SELECT "Early Shift", ChannelName, StartTime,EndTime, "MVS Checks" AS Quality

FROM MVSNotCheckedEarlyShift

UNION ALL

SELECT "Late Shift", ChannelName, StartTime,EndTime, "MVS Checks" AS Quality

FROM MVSNotCheckedLateShift

UNION ALL

SELECT "Night Shift", ChannelName, StartTime,EndTime, "MVS Checks" AS Quality

FROM MVSNotCheckedNightShift

UNION ALL

SELECT "Early Shift", ChannelName, StartTime,EndTime, "Laser Marking Checks" AS Quality

FROM LaserMarkingNotCheckedEarlyShift

UNION ALL

SELECT "Late Shift", ChannelName, StartTime,EndTime, "Laser Marking Checks" AS Quality

FROM LaserMarkingNotCheckedLateShift

UNION ALL SELECT "Night Shift", ChannelName,StartTime,EndTime, "Laser Marking Checks" AS Quality

FROM LaserMarkingNotCheckedLateShift;

Thanks

Jo