sql

dbma - ms access requirement build sql query to update running totals on a table. The table has a format as follows: BankTotalID Autonumber, BankAccountID Number, BankTotalDate DateTime, BankTotalAmount Currency, BankRunningTotal Currency BankTotalAmount is the total for the day's trade and the running total must be the sum of earlier days, eg opening balance = 30 day1 tot = 10, running = 40 day2 tot =67, running = 107 day3 tot = 89, running = 196 This must be a sinlge sql query to update the table or insert into a new table the running totals. There is NO programming for the task