Creating a new field from the Sum of an existing field

[#1]

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

[#2]

...to clarify somewhat: I have a table with two fields one date field and one balance field - there can be more than 1 rows per date with different balances for each row.

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

[#3]

Hi mauich123,

I think you should open a new thread with your new question(s). This thread has the green checkbox for solved threads, not much people will therefor watch it.

Regards

Roland