Query to display unmatch values

[JLS]

I have an table which has a field called Object Name that
contains two other fields... I need to create a query that
will display differences between the values of the two
fields in respect to the object name field. For example;

Object Name Field 1 Field 2
Gloves Rubber Gloves Rubber Gloves
Paper Wrapping Tissue

In the above example, these are two records that exsist in
the table. I want a query to display only record(s) that
have different values in field 1 and filed 2... so I want
the query to display only record 2 (they do not match).
How do I design this result?

 

[John Vinson]

I have an table which has a field called Object Name that
contains two other fields... I need to create a query that
will display differences between the values of the two
fields in respect to the object name field. For example;

Object Name Field 1 Field 2
Gloves Rubber Gloves Rubber Gloves
Paper Wrapping Tissue

In the above example, these are two records that exsist in
the table. I want a query to display only record(s) that
have different values in field 1 and filed 2... so I want
the query to display only record 2 (they do not match).
How do I design this result?

Simply create a Query based on your table; on the Criteria line under
[Field 2] type

<> [Field 1]

The less than - greater than <> symbol means "is not equal".

John W. Vinson[MVP]