How to sum colums with access

[Guest]

I have a table like this

Customer Week Begining Total week End

1 1 0 0 10
1 2 10


The end for week 2 have to be 20

How can I do that?

 

[Marshall Barton]

I have a table like this

Customer Week Begining Total week End

1 1 0 0 10
1 2 10


The end for week 2 have to be 20

Set the the End text box's control source the same as the
totalweek and its Running Sum property to
Over All or Over Group.