Sure was. Try this:
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 S
"Konchetta via AccessMonster.com" wrote:
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
.