This is what is giving me the syntax error: Syntax error in query expression '[Residence in] NOT Is Null'.
SELECT ID, "Res" As StipType, [Residence in] AS Stipulation FROM [Req&Stips] WHERE [Residence in]Not Is Null
UNION SELECT ID, "Fel", [Fellowship in] FROM [Req&Stips] WHERE [Fellowship in] Not Is Null
UNION SELECT ID, "SS", [Special Skills in] FROM [Req&Stips] WHERE [Special Skills in] Not Is Null
UNION SELECT ID, "Exp", [Experience in] FROM [Req&Stips] WHERE [Experience in] Not Is Null
UNION SELECT ID, "CA", [Contractual Arrangements] FROM [Req&Stip] WHERE [Contractual Arrangements] Not Is Null
UNION SELECT ID, "OS", [Other Stipulations] FROM [Req&Stips] WHERE [Other Stipulations] Not Is Null
UNION SELECT ID, "Req", [Requirements] FROM [Req&Stips] WHERE [Requirements] Not Is Null;