Here is what I have
SELECT SUPERVISOR, NAME, SCALENAME, SumOfINVDOLR, SumOfCONSDOLR, METRIC, YTD, SCALEMIN, SCALEMID, SCALEMAX
FROM MIOH_MONTH
WHERE YTD = Right([Forms].[Form1]![EndDate], 4) & " YTD"
UNION ALL
SELECT SUPERVISOR, NAME, SCALENAME, SumOfSALES, SumOfBOS, METRIC, YTD, SCALEMIN...