4 Replies Latest reply: May 15, 2014 9:55 AM by Mike Urbonas RSS

    Merging two fields into 1

    Fred _

      I'm having a problem with a report I'm working on.  Basicly I need to merge two columns into one.

      [font="courier"]TOTAL_ENTITLEMENT           DED      Merged column

                  Null      9,486.54      9,486.54

                  Null      4,699.75      4,699.75

                  Null      6,860.23      6,860.23

              4,278.59          Null      4,278.59  

                  Null      7,542.56      7,542.56

                  Null      8,182.79      8,182.79

                  Null      6,988.33      6,988.33

                  Null      5,418.67      5,418.67

                  Null      3,038.25      3,038.25

                  Null      1,610.84      1,610.84

                  Null      2,562.92      2,562.92

                  Null     12,514.81      2,514.81

                  Null      6,183.08      6,183.08

                  Null     12,120.19      2,120.19

              7,567.38          Null      7,567.38  

                  Null      9,031.24      9,031.24

                  Null      7,021.37      7,021.37

                  Null      6,760.13      6,760.13

                  Null      4,749.29      4,749.29

                  Null      9,173.00      9,173.00

                  Null      3,976.50      3,976.50

                  Null     12,542.24      2,542.24

                  Null     14,526.73      4,526.73

                  Null      4,920.69      4,920.69

                  Null      6,001.17      6,001.17

              4,391.32          Null      4,391.32 

                  Null      8,917.66      8,917.66  /font[/quote]As you can see I have two different fields with the same data.

      However the field called TOTAL_ENTITLEMENT was on a different line and would not trap with the field DED.  I know in V7

      there is an easy way to merge two fields columns into 1, but keep the data the same so  basicly where the Null on the

      DED field to be filled with the numbers from the TOTAL_ENTITLEMENT. I am using V6, if need be I will buy v7.