Hi

The following simple query returns:

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

Please Login or Register  to view this content.
But the following returns no error, and executes fine. The only difference is I removed the subquery:

Please Login or Register  to view this content.
Any help?