Access Assistance

[otis]

Somebody please help an Access Dummies. My administrative manager buy a yearly supplies for the office, and employees of various departments order supplies for office use. Please see below the example and help me out please, and trust me you will have a live long appreciation of a wonderful student. How do the effective get the balances. This database will be on a server. Help please

Examples of how it works at the office:

[June7]

Summarize transactions of stock received and stock distributed. This is what aggregate (GROUP BY) Totals queries are for. Calculate the difference.

Really need to know more about your data structure.