Which function to be use for showing balance quantity in a report?

[preeti]

I m working on inventory management system. In that I want to show the balance quantity after issuing a product to a user. How it possible to reflect the correct balance quantity in a report after every issue status. If there is return status then quantity should be added to the main quantity. Please help me for the logic. I want to reflect the balance in the report.

[CJ_London]

in a report you probably need to use the running sum property - see this link

https://msdn.microsoft.com/en-us/lib.../ff197062.aspx

[HiTechCoach]

If your database is well designed (normalized) then it should be a simple sum of the transactions.

This may help: Inventory Control: Quantity On Hand