18 Replies Latest reply: Oct 30, 2014 2:11 AM by PAUL YEO RSS

    How to list all duplicated record ?

    PAUL YEO

      Hi All

       

      The reasons is duplicated record , create issue on display price list as there are 2 record QV does not know which one to display. so i need to find out how many duplicated record in my

      database , and i need to manually delete those duplicated record.

       

      I like to know how to add one more expression at the enclosed table , which will indicate all duplicate record with "1" ?

       

      Below are the duplicated record :-

       

       

      FC9001-0010

      FC9002

      FC9004

      FC9011

       

       

      Paul