Help With Calculation Problem (1 Viewer)

[Timo4]

I am not sure which forum would be most appropriate for this question so I will post here. Keeping track of items donated and given out at our warehouses during a disaster has become more and more difficult to manage. Therefore we are trying to design a tool to address this and make this aspect of disaster response a little smoother.

I am trying to develop a Access database that will allow me to enter the number of items received and given out on a day by day basis and provide an on-demand report of how many items total are left in stock. I just can't seem to figure out how to perform the calculation giving the total so that it will show up in a report and also on the entry screen. Can anyone give me some
suggestions? Is this something that must be done with Pivot Table? I am
using Access XP.

Regards,
Tim

 

[Rich]

A simple Sum([ItemsRecd])-Sum([ItemsDesp]) will give stock on hand, using a totals query grouping by ItemID