[vinwin06]

Hi All,

I need an help in finding out duplicates values in two different columns. Like for example i have Column A and COlumn B , suppose if any value in Column B if its available in Column A then i need to update as "1" in column C. How i can do that in access. Becuase i tried to give the criteria as "Column A = COlumn B" but this is not working effectively. Find some samples below;

Column AColumn BColumn C1111245658796565879657896524789652456977455697745564789656478965202786520278647008874700887419898841989883697090369709031951913195191168949526932931187597219139468569851689495123456511875977899555568569854557899

In this example the second row value in Col A is available as first row value in COl B , in this case i need to update as "1" in col C in second row.

[draceplace]

VinWin, not able to follow your data or download the file at work...but Expr1: IIF([ColumnA]=[ColumnB],1,0) will be something like what you want.

[vinwin06]

I have tried with the same formula you have given but its updating all value as "0". i don't know whats wrong with the data.....

[draceplace]

that is correct, none of the data in the spread sheet matches A to B. the crap is off by a row or something. If you put this in C2:
=IF(A3=B2,1,0)

the matches are staggered for the first 9 rows then no matches. Garbage in garbage out.

[vinwin06]

yeah but how i will do it in access.... that is my concern

[draceplace]

If you want to find the matches you can pull the table in to a query 2 times and join it on its self A to B

[vinwin06]

i want those records when is A<> B

[draceplace]

You data is garbage, I don't see a viable resolution. You can join the table to its self A to B with a right or left join then take the nulls from one table and those will be non matched records. I'm not sure of thier value

[OBP]

So do you want to find duplicate values or where A<>B as stated in post #7?
Will all duplicates have a 1 placed in them?

[vinwin06]

I need to have values where A<>B , so it means that unique values in column A only be available.

[OBP]

Presumably you want to list the Unique Values, I think to do so you may need to have a new field in the table to indicate that the the value is duplicated somewhere in the database.
You can't do this with just one query, you may be able to identify them with 2, but maybe not.
I would need a table to play with.

[vinwin06]

Find attached the sample one i have posted....

[vinwin06]

In the sample i have attached if fun_2 column has one time "A0101" but if fun_1 has the same value several times means we need to delete it from Fun_1 column.

[OBP]

That data has a lot of duplication in field Fun_1, do you want unique values for that as well?
Can you show the output you want, does it include both fields?

[vinwin06]

No i want the result only in fun_1 but any value in fun_2 should not be in here in the result.