Please help.
I have an access table like below:
..........ColA | ColB
row1: Haga | "Good"
row2: Haga | "Dup"
row3: Stanton
I would like to have an expression in MS Access that compare row1 and row2 in ColA, if they are duplicate, then display "Good" in row1 of ColB and display "Dup" in row2 of ColB.
Thanks for your help.