11 Replies Latest reply: Oct 23, 2010 6:08 PM by Roland Kunle RSS

    Creating a new field from the Sum of an existing field

    mauich123

      Hi. I'm new to QV and hope someone here can help me out :)

      I have a table with two fields with this kind of structure:

      Field1 - Field 2

      10 - A
      100 - A
      1000 - A
      20 - B
      50 - C
      500 - C

      What I want to do is to take this information and create a new table with the sums of Field1 for represented for each Field2, like so:

      1110 - A
      20 - B
      550 - C

      I would like to do this in the script. What's the easiest way?

      Thanks!

      /M