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.