MS Access - Query with criterion

I have a database with a text field that determines a future action. In some of the records that text field says "DELETE ". I don't want to delete the record YET, but I want to make a query that leaves out all records that have DELETE in that field

I have tried = NULL <> "delete" <> "DELETE "

What is the correct statement?

 

NULL <> "delete" AND NULL <> "DELETE
Not sure !
Regards

 

I found out why you were not sure. Not workable

 

Posting all the query text may be a good idea ...
regards

 

It's the last criterion that is the one in question
=====================================

SELECT [SouthNassauSHHH to 3/2/03].PaidThru, [SouthNassauSHHH to 3/2/03].[Last Name], [SouthNassauSHHH to 3/2/03].[First Name], [SouthNassauSHHH to 3/2/03].Business, [SouthNassauSHHH to 3/2/03].Address, [SouthNassauSHHH to 3/2/03].Town, [SouthNassauSHHH to 3/2/03].St, [SouthNassauSHHH to 3/2/03].Zip, [SouthNassauSHHH to 3/2/03].[Member Description], [SouthNassauSHHH to 3/2/03].[Newsletter Status]
FROM [SouthNassauSHHH to 3/2/03]
WHERE ((([SouthNassauSHHH to 3/2/03].[Newsletter Status])<> "delete" And ([SouthNassauSHHH to 3/2/03].[Newsletter Status])<> "DELETE "))

 

My problem seems to be constructing a query when one field is partly NULL. The field I mentioned has mostly no entries but some have "R ". I want to create the ones without an "R ".

Since the field is a text field, is that what is causing the trouble. Do have to say > "R" to get " ".

 

Why are you testing the fields contents as "delete" or "DELETE "
if it can only contain blanks or "R "
Do not follow ...
regards

 

I'm not. It is this field that I am testing below that is tested for delete . It can be null or Delete

Newsletter Status])<> "delete

The problem field is tne temp field that could be "R' I want to view all the records without the "R "

 

Do not understand what field you are referring to :
"the temp field" ??
regards

 

SELECT [SouthNassauSHHH to 3/2/03].JoinDate, [SouthNassauSHHH to 3/2/03].PaidThru, [SouthNassauSHHH to 3/2/03].[First Name], [SouthNassauSHHH to 3/2/03].[Last Name], [SouthNassauSHHH to 3/2/03].[Member Description], [SouthNassauSHHH to 3/2/03].Business, [SouthNassauSHHH to 3/2/03].TempMarking
FROM [SouthNassauSHHH to 3/2/03]
WHERE ((([SouthNassauSHHH to 3/2/03].[Member Description])= "X" Or ([SouthNassauSHHH to 3/2/03].[Member Description])= "C ") AND (([SouthNassauSHHH to 3/2/03].TempMarking)<> "R "));


The last field, as it is, yields ONE blank record and I want to show all records that do not have an "R" there. Those fields right now are blank (or all spaces, dont know which) It is a text field of length 10.

 

i would recommend you visiting this forum , it is dedicated to MS Access only and there are plenty of members their, that are more into the field.

Hope you solve your problem !

 

I agree with Max - especially as the query seems to vary in content quite often.
I cannot help further, sorry.
regards