So below is my code.
SELECT [Location], [DeptID], [Name], [ID], [1], [STD Hrs/WK], [1], [Acct Code], [Pay Status], [Eff Date], [Last Start], [Reg/Temp], [Full/Part], [Mail Drop], [Expected Return Date], [Action], [Reason], [Job Code], [Job Code Descr], [Contract #]
From [Support Active Table]
WHERE ([Contract #] <> "")
UNION SELECT [Location], [DeptID], [Name], [ID], [1], [STD Hrs/WK], [1], [Acct Code], [Pay Status], [Eff Date], [Last Start], [Reg/Temp], [Full/Part], [Mail Drop], [Expected Return Date], [Action], [Reason], [Job Code], [Job Code Descr], [Contract #]
From [NBPU List]
WHERE ([Contract #] <> "")
I want to write in my WHERE a does not begin with [Acct Code] '72801011'