ms access - Complex sum in SQL -

ms access - Complex sum in SQL -

suppose have:

a b andy 10 andy 20 andy 30 andy 40 paul 10 paul 50 ryan 3

... , want result be:

a b c andy 10 10 andy 20 30 andy 30 60 andy 40 100 paul 10 10 paul 50 60 ryan 3 3

what query accomplish me? think of c cumulative frequency.

one way it.. untested suggestion... sub-select totals relevant values match , in order before current line...

select name a, value b, ( select sum(value) the_table t2 t2.name=t1.name , t2.second_order_field<=t1.second_order_field ) c the_table t1 order t1.name,t1.second_order_field

sql ms-access grouping aggregation