Comparing data

  • Thread starter Thread starter EMILYTAN via AccessMonster.com
  • Start date Start date
E

EMILYTAN via AccessMonster.com

There are 2 column in this query:-

Column 1 Column 2
A A
B C
C E
D D

I want this 2 column to compare. If both A, display A, if different compare
next 1...However, the result of the third column will give me all A,C,D
without B and E included at the last row?
Any idea to make them show all A,C,D,B,E?
 
There are 2 column in this query:-

Column 1 Column 2
A A
B C
C E
D D

I want this 2 column to compare. If both A, display A, if different compare
next 1...However, the result of the third column will give me all A,C,D
without B and E included at the last row?
Any idea to make them show all A,C,D,B,E?
Click to expand...

I've looked this message over three times now and I still cannot understand
what you want.

How are you "comparing"? Are these two fields in the same table, or in
different tables? Do Since E does not appear anywhere in Column1, and B does
not appear in Column2, why would you expect them to appear? They DON'T match!

What *REAL LIFE* problem are you trying to solve, and what are the actual
values in these tables?

John W. Vinson [MVP]
 
Back
Top