Thanks Daryl, I will try this. I will appreciate your help.
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 AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201005/1