Hi

The following simple query returns:

"Access database engine does not recognize OuterTbl.TJC as a valid fieldname or expression"

SELECT OuterTbl.TJC, (Select count (surveyid) from InnerTbl Where TJC = OuterTbl.TJC) AS Surveys
FROM OuterTbl
GROUP BY OuterTbl.TJC
But the following returns no error, and executes fine. The only difference is I removed the subquery:

SELECT OuterTbl.TJC 
FROM OuterTbl
GROUP BY OuterTbl.TJC
Any help?