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


|