9 Replies Latest reply: Oct 25, 2010 8:10 AM by Roland Kunle RSS

    Collecting the sum of fields


      Hi! I'm pretty new to QV and would like to write a script that does the following:

      I have a table with two fields : one date field and one value field - there can be more than 1 row per date with different values for each row.

      I want to create a new table where a row = the date field + the sum of all value fields for that date PLUS the sum of the balance fields for all previous dates.

      Hope some one can help me with this :) Thanks!