View Single Post
  #8  
Old May 28th, 2010, 06:44 PM posted to microsoft.public.access.forms
Daryl S[_2_]
external usenet poster
 
Posts: 881
Default Datasheet Subform Query

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

.