Equation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a query, I would like to write an equation or condition, so that I can
generate a report for all item "except ___". For example, the report should
run every item that does not have "C" in the status field. Is there an
equation or condition, "no equal to"?

Sorry if this is an easy one!
Emmz
 
In a query put the following under the Status field in the criteria row:

<> "C"

Base the report on this query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query using more than one equation for a field calc 1
Error in equation 1
Parameter Value Entry 5
use different equations in same query field 2
Assigning records to users 2
Query Equation 2
Convert Some field Entries to negative Numbers 2
IF, AND & OR 3

Back
Top