Duplicate Identifier

[niri77]

hello,

In excel i used the following formula =IF(COUNTIF(U$2:U$900,U3)>1,"Duplicate","")on one field to find duplicate, but I cannot come up with similar formula on column fields in a table.

Any guidance?

Thank you in advance

Niri

 

[mdb4me]

Under Queries in the database window, select New and the dialog box lists a number of query wizards. Choose Find Duplicates Query Wizard.