Is there a running sum function for queries, As there in reports

[shirsch]

The running sum function in reports is exactly what i need. But I cannot find
the fuction in queries or forms

I have a table with 3 field call term.

Link id (links record to master receord)
year (one two or three etc)
pct (percent to increase)

This is a one to many setup. This is the many table that links to a single
master record by link id.

The base rent amount is posted in the master table. In this example the base
rent is $10.

The use then post the year number and the pct increase in the term table.

for example:

in the master record the base rent is $10

In the term the user post the following data:

year 1 pct 0
year 2 pct 5 this is a 5% increase over the base rt

Year 3 pct 4 Total increase over base 9%
year 4 pct 5 Total increase over base 14%

I need to cal what the adj base is for each record. How do I calculate the
running total of the percentages.

 

[[MVP] S.Clark]

Not really, but you can use an update query to update the values in a stored
table.