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.