Recent content by derekwit

this code finds all data with an "x" <>", 'X'" what code do I use to find everthing that does not have an "x"

<>'x' is what I inserted into the cirteria section under the field completed in my query. When I go back to the report no results are shown. What am I doing wrong?

Not to be dumb... You said "which you need to enter under the field with the complete flag on the criteria line" what is the complete flag. I tried what you said in the critera section putting <> "A" and there were no results shown. May it has something to do with the complete flag.

Now I am new to Access do I do this as an expression in expression builder after I have created a query or report? Or do I have to create this expression first?

I have used Excel for many years and used the if formula. I have just started using access and need a little help. I have a table the has 20 fields. I am only concerned with about 8 of these fields for a report. I have a field named completed in this field I put a "x" if the job is complete...