The following subquery
Select *
From tbl_Combined_Assess3WQs
Where C > 1
(Select [WQ ID], Count([WQ ID]) as C
From tbl_Combined_Assess3WQs
Group By [WQ ID]);
is issuing the following syntax error
Invalid use of '.' , '!', or '()' in query expression 'C > 1
(Select [WQ ID], Count([WQ ID]) as C
From tbl_Combined_Assess3WQs
Group By [WQ ID]'.