a query which compares two columns in a table

[Guest]

I'm trying to develop a query which takes two columns from a table, compares
the values, and only displays the values in those two fields when they are
not equal.

 

[Joseph Meehan]

I'm trying to develop a query which takes two columns from a table,
compares the values, and only displays the values in those two fields
when they are not equal.

What do you want to display when they are equal and what do you want to
display when they are not?

 

[John Vinson]

I'm trying to develop a query which takes two columns from a table, compares
the values, and only displays the values in those two fields when they are
not equal.

If the fields are named FieldA and FieldB, create a Query selecting
whatever you want to see; on the Criteria line under FieldB put

<> [FieldA]

The square brackets are essential, since otherwise it will show you
all records where FieldB is not equal to the literal text string
"FieldA".

John W. Vinson[MVP]