Select or Delete based on text criteris

I am trying to use a delete query in Access 2013.  I have done it a million times before in other versions.  If I put in my criteria "Ohio", Up pops all the Ohio data.  If I put <>"Ohio" I get nothing, Not In("Ohio"), or Not In('Ohio') still nothing.  Same results for a select query.  The field is Short text 256 Characters.  Any help would be appreciated.  Yes there is other data.
vmccuneAsked:
Who is Participating?
 
Dale FyeConnect With a Mentor Commented:
keep in mind that NULL values will be handled differently.
0
 
Ryan ChongCommented:
perhaps 2 things to verify:

1) go to SQL view for your View and check what SQL was being generated.. share it here if necessary
2) check your data, make sure there's data available in your selection criteria
0
 
vmccuneAuthor Commented:
OK. Here is a Delete that works:
DELETE tblNonEmp.*, tblNonEmp.ReprocessAction
FROM tblNonEmp
WHERE (((tblNonEmp.ReprocessAction)="Reprocess"));

And same as Select
SELECT tblNonEmp.*, tblNonEmp.ReprocessAction
FROM tblNonEmp
WHERE (((tblNonEmp.ReprocessAction)="Reprocess"));

And trying to get the Opposite Select that does not work
SELECT tblNonEmp.*, tblNonEmp.ReprocessAction
FROM tblNonEmp
WHERE ((Not (tblNonEmp.ReprocessAction)="Reprocess"));

and not work
SELECT tblNonEmp.*, tblNonEmp.ReprocessAction
FROM tblNonEmp
WHERE (((tblNonEmp.ReprocessAction)<>"Reprocess"));

SELECT tblNonEmp.*, tblNonEmp.ReprocessAction
FROM tblNonEmp
WHERE (((tblNonEmp.ReprocessAction) Not In ("Reprocess")));

I think Dale has my answer and I need a second criteria row for isnull But I don't remember needing to do this before.  Any help is appreciated.
0
 
Luke ChungPresidentCommented:
Why is a field specified,  tblNonEmp.ReprocessAction, in a delete query?
0
 
vmccuneAuthor Commented:
The null was the issue.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.