Prev: Query Criteria to Identify Expired Credit Cards
Next: Kellner Kellnerin Metallbauer Metallbauerin Bautechniker Bautechnikerin Vertriebsingenieur Vertriebsingenieurin
From: jfcby on 25 Jun 2008 07:25
Hi,

How can the Miscrosoft Access 2003 SQL statement be changed so that
the operator Not Like will work?

When I view the query the data I want excluded is still included...

SELECT ROOT_AE_P_PRO_E.PROPOSAL, ROOT_AE_S_BLD_C.BLDG,
ROOT_AE_S_BLD_C.BLDGDSC, ROOT_AE_P_PRO_E.REQUESTOR,
ROOT_AE_P_PHS_E.SHOP, ROOT_AE_P_PRO_E.PROGRAM_FY,
ROOT_AE_P_PRO_E.TITLE, ROOT_AE_S_BLD_C.BLDG_CITY
FROM (ROOT_AE_P_PHS_E INNER JOIN ROOT_AE_P_PRO_E ON
ROOT_AE_P_PHS_E.PROPOSAL = ROOT_AE_P_PRO_E.PROPOSAL) INNER JOIN
ROOT_AE_S_BLD_C ON ROOT_AE_P_PRO_E.BLDG = ROOT_AE_S_BLD_C.BLDG
WHERE (((ROOT_AE_P_PRO_E.PROPOSAL) Not Like"*02312") AND
((ROOT_AE_P_PHS_E.SHOP)="48") AND ((ROOT_AE_P_PRO_E.PROGRAM_FY)="09")
AND ((ROOT_AE_P_PRO_E.TITLE) Like "WORK REQUEST FOR RI BUILDING:*"))
ORDER BY ROOT_AE_P_PRO_E.PROPOSAL;


Thank you for your help,
Frankie

From: Stuart McCall on 25 Jun 2008 08:49
Change this:

> WHERE (((ROOT_AE_P_PRO_E.PROPOSAL) Not Like"*02312") AND

to this:

WHERE Not ROOT_AE_P_PRO_E.PROPOSAL Like"*02312" AND

(I removed the parens for clarity - if you type the line in as above, Access
will put them back in)


From: jfcby on 25 Jun 2008 09:33

>
> WHERE Not ROOT_AE_P_PRO_E.PROPOSAL Like"*02312" AND
>

Above Did not work.

But this did work:

WHERE ROOT_AE_P_PRO_E.PROPOSAL Not Like"*02312*" AND

Thanks for your help,
jfcby

 | 
Pages: 1
Prev: Query Criteria to Identify Expired Credit Cards
Next: Kellner Kellnerin Metallbauer Metallbauerin Bautechniker Bautechnikerin Vertriebsingenieur Vertriebsingenieurin