Prev: Wild card not working in Access 2010 query
Next: Very Simple Question
From: Konchetta via AccessMonster.com on 28 May 2010 12:25
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/Forums.aspx/access-forms/201005/1

From: Konchetta via AccessMonster.com on 28 May 2010 12:27
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

From: Daryl S on 28 May 2010 13:44
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
>
> .
>
From: Konchetta via AccessMonster.com on 28 May 2010 13:53
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

First  |  Prev  | 
Pages: 1 2
Prev: Wild card not working in Access 2010 query
Next: Very Simple Question