Calculate Query (1 Viewer)

[xdenama]

guys, i need your help. i want to calculate the company expenses and income by months according to variant department in the company. Every data will be recorded based on the respective department. however, i dont have any idea how to calculate the BALANCE field (auto calculate, I prefer query) after i have recorded my GRANT field and my EXPENSES field. The GRANT field can be grow by add new "grant".

I attch my database.

 

[MarkK]

Typically to calculate a balance you sum all the "debits" and "credits" in your system, so in an inventory system you might sum all your purchase orders with all your sales orders for each product quantity. Then you can calculate that balance on any day, since your POs and SalesOrders will all be dated.

For a balance in an account, you sum all the transactions in and out up to a certain date.

I have not looked you the database you posted.

Hope this helps,

 

[arnelgp]

see query1

 

[xdenama]

Thank you very much...