Hi,
Please let me know whats wrong with syntax of the following query, its written in MS Access format:
Select count(*) from [Demographics/Job Data Table] D1 WHERE EXISTS (Select (*) from [Demographics/Job Data Table] D2 where [D2].[Supervisor ID] = [D1].[Employee #] and [D2].[Termination]=Yes)
I am getting a syntax error message when I try to save this query in Access. :(