Query does not filter records

[kbestle]

I have a table that has a field that contains data like 04 or UB or NX. I have a query that the criteria on this field is <> "NX". When I run the query I still see some records with this entry. I have also tried Not "NX". I am using Access 2007. Any insights will be greatly appreciated.

 

[PWise]

are there any other criteria

 

[PHV]

Post the SQL code.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kbestle]

SELECT dbo_qryAssignedPSRs.PartNo, dbo_qryAssignedPSRs.Description, dbo_qryAssignedPSRs.InventoryPlanning
FROM dbo_qryAssignedPSRs
WHERE (((dbo_qryAssignedPSRs.InventoryPlanning)<>"nx"));

 

[PHV]

I'd replace this:
WHERE (((dbo_qryAssignedPSRs.InventoryPlanning)<>"nx"))
with this:
WHERE dbo_qryAssignedPSRs.InventoryPlanning<>'NX'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JoeAtWork]

Are there spaces in the results, e.g. "NX "

Try this:

WHERE Trim(dbo_qryAssignedPSRs.InventoryPlanning)<>"NX"


Joe Schwarz
Custom Software Developer

http://www.plandev.net