I am familiar with finding and identifying duplicate column in excel sheet using the formula below
=IF(COUNTIF(A:A,A1)>1,0,1)
with the first occurrence of the duplicate flagged as 1 and second occurrence flagged with 0
I am working in access database and would like to create similar field in access using expression builder function.
I am trying not to work in both excel and access.
Thank you immensely in advance for your assistance
=IF(COUNTIF(A:A,A1)>1,0,1)
with the first occurrence of the duplicate flagged as 1 and second occurrence flagged with 0
I am working in access database and would like to create similar field in access using expression builder function.
I am trying not to work in both excel and access.
Thank you immensely in advance for your assistance