Running Total

[TINMAN]

I have a calculated field in a Microsoft Access Query (qry-Report01B) called DimensionInches that calculates the dimension in inches from fields for feet, inches, fraction numerator, and fraction denominator.

I would like to create another field called RT (for Running Total) just to the right of the DimensionInches field (column) in the query which would give a running total column for the dimension field. I tried creating a calculated field RT using the Dsum function but it wouldn't give me the desired results.

RTSum(“[DimensionInches]”,”qry-Report01B”)


DimensionInches RT

1.00000 6.00000
3.00000 6.00000
2.00000 6.00000

This Dsum function is giving me a total of all records in the query.

I would like to result for RT to be 1.00000, 4.00000, 6.00000

Any suggestions for a novice Access user.

[June7]

Easiest method is to build a report and use textbox RunningSum property.

For a query, review https://docs.microsoft.com/en-us/off...g-totals-query

[TINMAN]

Thank you for your response I have created a report using the textbox RunningSum property which gave me the correct results.

I have also created a running total field in the query using the DSUM function which gives me the correct running total.

However, when I tried to use a parameter query to limit the results to a certain group of records I get an error message. Now I will have to try and figure out a way around this issue, again thanks for your help.