Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Calculate Running Total in a New Field

Avatar of squishking1
squishking1 asked on
Microsoft Access
20 Comments1 Solution548 ViewsLast Modified:
I am trying to calculate the running sum and saving the results in a new field either in the same table or a new one.  

To help explain, I've attached sample DB with the original table (tblTestData) and the desired output (Desired Output).  Basically - for each change in field PARE, calculate the running sum QTY_ONHAND - REQ_QTY  and store in field called Balance.

The table is sorted by PART and DUE_DATE.

I've also attached Excel file with function logic used to calculate the desired results.  Looking for something similar to do in Access.

Prefer a solution using queries/macros as I am not very strong w/VBA but could manage if it is not too complicated.

Thanks.




Desired-Result.xlsx
TestDB3.accdb
ASKER CERTIFIED SOLUTION
Avatar of Hamed Nasr
Hamed NasrFlag of Oman imageRetired IT Professional

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 20 Comments.
See Answers