Hi
The following simple query returns:
"Access database engine does not recognize OuterTbl.TJC as a valid fieldname or expression"
But the following returns no error, and executes fine. The only difference is I removed the subquery:SELECT OuterTbl.TJC, (Select count (surveyid) from InnerTbl Where TJC = OuterTbl.TJC) AS Surveys FROM OuterTbl GROUP BY OuterTbl.TJC
Any help?SELECT OuterTbl.TJC FROM OuterTbl GROUP BY OuterTbl.TJC
Bookmarks