Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > How to use oper...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 30578 of 31576
Post > Topic >>

How to use operators Like and Not Like together?

by jfcby <jamesfc30@[EMAIL PROTECTED] > Jun 25, 2008 at 04:25 AM

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
 




 3 Posts in Topic:
How to use operators Like and Not Like together?
jfcby <jamesfc30@[EMAI  2008-06-25 04:25:52 
Re: How to use operators Like and Not Like together?
"Stuart McCall"  2008-06-25 13:49:16 
Re: How to use operators Like and Not Like together?
jfcby <jamesfc30@[EMAI  2008-06-25 06:33:03 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 23:11:06 CST 2008.