I am attempting to setup database for inventory and running totals

T

Thomas

Hello Everyone,

I am attempting to setup a database where the end result is a running total
of inventory. For example, I have 100 bottles arrive. 20 bottles are shipped.
The remaining total should be brought over so that when another 100 bottles
come in, I will have 180 bottles in inventory. I have already created the
tables for all my inventory. How can I keep a running total or running count
in Access??
Thanx
Thomas
 
Top