New to Access help with easy query

[derekwit]

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. I would like to create a report that shows me all active jobs. Everything that does not have an "x" in complete field. Can somebody either direct my to the forums I should be in or possible give me the correct coding. Thanks for your help in advance.

 

[antomack]

Not sure if this is what you mean but is it as simple as writing the query to return all records where the required field is not 'x'. If so then SQL as follows should work

SELECT Field1, Field2, Field3, ...... FROM Table
WHERE RequiredField <> 'x';

 

[derekwit]

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?

 

[antomack]

Just build your query in the normal way and add the fields you want to see. Ensure that the field with the 'x' flag is included, if you don't want it to display then just untick the Show box.

You then need to enter the criteria you want to use for the query in your case this criteria is
<> 'x'
which you need to enter under the field with the complete flag on the criteria line

 

[derekwit]

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.

 

[antomack]

The complete flag is referring to the field that you set with an 'x' for complete, with 'x' being the flag that the process is completed.

The <> 'x' criteria should give you all records where the field is not set to 'x'

 

[derekwit]

<>'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?

 

[derekwit]

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

 

[antomack]

If the <> doesn't work then try the word Not as in
Not 'x'

or if the field contains nothing when not completed and 'x' where completed then use
Is Null