CoolFactor
Technical User
All I want to do is to exclude [S8] AS SFTE and [S9] AS SFTE
from the Union query
SELECT qry_Smoother2.Location, 'Y0' AS YEAR, [Y0] AS FTE, 'S0' AS S, [S0] AS SFTE
FROM qry_Smoother2;
UNION ALL
SELECT qry_Smoother2.Location, 'Y1' AS YEAR, [Y1] AS FTE, 'S1' AS S, [S1] AS SFTE
FROM qry_Smoother2;
UNION ALL
SELECT qry_Smoother2.Location, 'Y2' AS YEAR, [Y2] AS FTE, 'S2' AS S, [S2] AS SFTE
FROM qry_Smoother2;
UNION ALL
SELECT qry_Smoother2.Location, 'Y3' AS YEAR, [Y3] AS FTE, 'S3' AS S, [S3] AS SFTE
FROM qry_Smoother2;
UNION ALL
SELECT qry_Smoother2.Location, 'Y4' AS YEAR, [Y4] AS FTE, 'S4' AS S, [S4] AS SFTE
FROM qry_Smoother2;
UNION ALL
SELECT qry_Smoother2.Location, 'Y5' AS YEAR, [Y5] AS FTE, 'S5' AS S, [S5] AS SFTE
FROM qry_Smoother2;
UNION ALL
SELECT qry_Smoother2.Location, 'Y6' AS YEAR, [Y6] AS FTE, 'S6' AS S, [S6] AS SFTE
FROM qry_Smoother2;
UNION ALL
SELECT qry_Smoother2.Location, 'Y7' AS YEAR, [Y7] AS FTE, 'S7' AS S, [S7] AS SFTE
FROM qry_Smoother2;
UNION ALL
SELECT qry_Smoother2.Location, 'Y8' AS YEAR, [Y8] AS FTE,'S8' AS S, [S8] AS SFTE
FROM qry_Smoother2;
UNION ALL SELECT qry_Smoother2.Location, 'Y9' AS YEAR, [Y9] AS FTE, 'S9' AS S, [S9] AS SFTE
FROM qry_Smoother2;