Define Correct Criteria

[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

 

[Jeanette Cunningham]

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