"not equals to" problem

[bharnett]

I have a query that pulls data from a large table of trades. One of the fields in this table is "Status Flag." It shows a "C" when the has been cancelled. I want the query to include only records without this "C". I put <> "C" in the Criteria field in design view, but this didn't work and returned no results. I put = "C" in the Criteria field, and this showed me the two trades that are cancelled, but nothing else. So I know it is reading the "C" correctly, but I have no idea how to exclude it. I also tried using the "Not" operator to get this to work but with the same result. How does this work? I can't get it to just show me the active deals only.

 

[Joe4]

What are the other options this flag can be (other than "C")? Can it be blank?

Are you sure you do not have any other criteria (on other fields) that may be interfering with your testing?

 

[bharnett]

yes it is either "C" or blank. I want all the records with the blank...

 

[Joe4]

Try using Is Null as your criteria.

 

[bharnett]

Thank you,
You rule!!!