I have been trying to execute the following query in table adapter in the Microsoft Visual Studio 2005. I am accessing a Microsoft Access Database.

But I keep getting the SQL Syntax Error: Unable to Parse Query Text

SELECT COUNT(*)
FROM
(SELECT DISTINCT[P A].[Last Name]
FROM [P A]
WHERE ([P A].[Month] = @Month) AND ([P A].[Code] = @code));

I am not sure how to handle this error. Please advice

Thanks