Is there a formula that will compare elements in one column to an.

  • Thread starter Is there a compare function or formula?
  • Start date
I

Is there a compare function or formula?

Can I compare information in one column with information in another column
and highlight the results?
 
M

Mike Labosh

Can I compare information in one column with information in another column
and highlight the results?
Click to expand...

SELECT * FROM YourTable WHERE ThisColumn = ThatColumn
 
D

Douglas J. Steele

Or

SELECT *, IIf([ThisColumn] = [ThatColumn], "Same", "Different") AS
Comparison
 
Top