I want to add suffix to all duplicate fields on my table.
Ex.
Table 1
abcde
abcde
abcde
fghij
fghij
klmno
Expected Result
Table 1
abcde(1)
abcde(2)
abcde(3)
fghij(1)
fghij(2)
klmno
Any idea how I can accomplish this task using MS ACCESS??? Thank you.