Z has made most of the points I would have Silbon. I would just like to emphasize, for any future questions you may have here, that what you came up with after three posts and some prompting is the bare minimum that should have been in the first post. It could be laid out more clearly but it does at least have all the pertinent information. You need to understand that we aren't here to spend time eliciting from you all the details that you, as an intelligent adult working in databases, should know are needed.
As for your question, it seems that
Running Sum isn't even required here (If I read the PDF correctly). You would need a Header and Footer for the Part. In the Header you would show the raw value from the Part table (The Brought Forward Balance). In the Detail you would simply show the value for each transaction. No
Running Sum. In the Footer you would have two controls :
- To sum the values from the Transactions. Use a formula
=Sum([TranValue]
. - To show the new total. Use a formula
=[B/F] + [TranSum]
(Where [B/F] comes from the Part table and [TranSum] is the field from point #1).