Import Data from Access/Query Criteria Not Enforced in Output
 

Excel 2002
Access 2002
I'm importing external data into an Excel workbook from an Access database.
Criteria set in Access query does not filter the records output in Excel.
This only seems to be a problem on this one external link. Two others
function properly with similar filtering criteria.


SELECT CCR.State, CCR.Hub, CCR.[Device CLLI], CCR.Equipment AS Node,
Location.LATA, CCR.[Job Type], CCR.CCR, CCR.[Current Exhaust Date Due],
CCR.Status, CCR.Notes, CCR.[Target Handoff to NDNC-IP] AS [Target Handoff to
NDNC-IP], CCR.[Actual Handoff to NDNC-IP] AS [Actual Handoff to NDNC-IP],
CCR.ID
FROM CCR LEFT JOIN Location ON CCR.Hub = Location.Hub
WHERE (((CCR.[Job Type])="ERX") AND ((CCR.Status) Not Like "*Cancel*" And
(CCR.Status) Not Like "*RFS*")) OR (((CCR.[Job Type])="ERX CA") AND
((CCR.Status) Not Like "*Cancel*" And (CCR.Status) Not Like "*RFS*"))
ORDER BY CCR.[Target Handoff to NDNC-IP], CCR.[Actual Handoff to NDNC-IP];