hello Daryl,
It says there is an extra ) in query expression...

Daryl S wrote:
Konchetta -

This query will show you all MainProjectList records that don't have a 2009
or 2010 tblAOCFees record (untested):

SELECT MainProjectList.*
FROM MainProjectList
WHERE ((MainProjectList.[Inactivate Record])=False))
AND (Not exists (SELECT 'X' FROM tblAOCFees WHERE
MainProjectList.Project_ID = tblAOCFees.Project_ID
AND tblAOCFees.CalendarYear in (2009, 2010)));

Daryl,

[quoted text clipped - 45 lines]

Thanks in advance for your assistance!!

--
Message posted via http://www.accessmonster.com