a query which compares two columns in a table

P

pihrana52583

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.
 
J

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.
Click to expand...

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]
 
Top