Define Correct Criteria

  • Thread starter Thread starter ttp
  • Start date Start date
T

ttp

I need assistance in trying to obtain the correct results from a query.
Below is a snapshot of the table that is used. The query results should not
include any records with GENERATOR in TURBINE_TECH field and GCE in
ORDER_SOURCE field. For instance, my results should not include Order_Num
1041772 from the table below. How do I write the criteria associated with
this?

ORDER_NUM TURBINE_TECH ORDER_TYPE ORDER_SOURCE
1041772 GENERATOR Contractual Services GCE
1041812 STEAM Energy Parts - GEII Copy
1041818 GENERATOR Performance Services EAM AUTOLOAD
1041911 STEAM Energy Parts - GEII GCE
1000075 GENERATOR Performance Services CONVORDERS

Can anyone help me in writing the criteria and setting up the query correctly?

Thanks in advance
 
Hi ttp,
in the query, in the criteria row under the field called TURBINE_TECH
type
<>"Generator"

in the same row, under the field called ORDER_SOURCE
type
<>"gce"

The query will then exclude all records with both generator and gce in the
same row.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Back
Top