2 Replies Latest reply: May 15, 2014 9:53 AM by joey RSS

    Suppress duplicates

    Jim R

      I'm suppressing duplicates in column1 and column2

      lines 2,4,5,6,7,8,9  column1=RD;column2=11/01/07;column3=123456;column4=102.00

      1  RD     11/1/07 123456   102.00

      2 suppressing duplicates

      3                789100   100.00

      4 suppressing duplicates

      5 suppressing duplicates

      6 suppressing duplicates

      7 suppressing duplicates

      8 suppressing duplicates

      9 suppressing duplicates

      What I would like to do is have column1 show RD and column 2 show 11/1/07 on line 3

      How do I get this to work?

      I hope I explained it right

      Any help will be appreciated

        • Suppress duplicates
          Grant Perkins

          Posted to format sample.

           

          [font="courier"]1  RD     11/1/07 123456   102.00

          2 suppressing duplicates

          3                 789100   100.00

          4 suppressing duplicates

          5 suppressing duplicates

          6 suppressing duplicates

          7 suppressing duplicates

          8 suppressing duplicates

          9 suppressing duplicates[/font][/quote]What I would like to do is have column1 show RD and column 2 show 11/1/07 on line 3

          How do I get this to work?

          I hope I explained it right

          Any help will be appreciated

           

          [size="1"][ November 12, 2007, 03:10 PM: Message edited by: Grant Perkins ][/size]

          • Suppress duplicates
            joey

            In the field properties for column 1 and column 2, try changing Empty Cells from Leave blank to Copy value from previous record.