I think I got it to work Mr. Daryl. Another question, for upcoming years that
we receive fees, should I just add that calendar year to the query?

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