Hi Guys
I have been trying to retreive data from a table that meets the criteria that I have put in but I am getting everything from the table even stuff that does not meet the criteria. The query is below
SELECT tblPOCommittment.responsibility, tblPOCommittment.authsdDate, tblPOCommittment.supplierNo, tblPOCommittment.preqNumber, tblPOCommittment.preqItemNumber, tblPOCommittment.poNumber, tblPOCommittment.poItemNumber, tblPOCommittment.itemDescription, tblPOCommittment.cmsFacility, tblPOCommittment.cmsCommodity, tblPOCommittment.carNumber, tblPOCommittment.PoQty, tblPOCommittment.PoAmount, tblPOCommittment.packageName, tblPOCommittment.ContractorVendorName, tblPOCommittment.PhaseCode, tblPOCommittment.PaymentType, tblPOCommittment.UnitofMeasure, tblPOCommittment.TermsNotes, tblPOCommittment.RevisionNumber
FROM tblPOCommittment
WHERE (((tblPOCommittment.cmsFacility) Is Not Null)) OR (((tblPOCommittment.cmsCommodity) Is Not Null)) OR (((tblPOCommittment.carNumber) Is Not Null)) OR (((tblPOCommittment.cmsFacility) Not Like "N*")) OR (((tblPOCommittment.cmsCommodity) Not Like "N*")) OR (((tblPOCommittment.carNumber) Not Like "N*")) OR (((tblPOCommittment.cmsFacility) Not Like "")) OR (((tblPOCommittment.cmsCommodity) Not Like "")) OR (((tblPOCommittment.carNumber) Not Like ""));