How can I compare columns?

  • Thread starter Thread starter Jeanne T
  • Start date Start date
J

Jeanne T

How can I compare column A to columns B, C, D and E to see if the same value
from column A exists in Columns B, C, D or E? What function can I use?
 
Assuming you are doing this in a query and you want a value in the row to
show that a match exists, you could use the following expression as a
calculated column

IIF([A] In (,[C],[D],[E]), "Match Found","No Match")



--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
How can I compare column A to columns B, C, D and E to see if the same value
from column A exists in Columns B, C, D or E? What function can I use?
Click to expand...

What's the context? A Query on a table? What is the real-life meaning of these
columns?

A Query with a criterion

WHERE [A] = OR [A] = [C] OR [A] = [D] OR [A]=[E]

would do the job... but the need to do this makes me very suspicious of your
table structure!
 
Back
Top