How to carry new totals

[Guest]

I have a databse created already. I need to carry over new totals after items
have been shipped.

 

[Ken Snell \(MVP\)]

Assuming that your table has a field for "quantity" that is positive when
added to inventory and negative when shipped, you can use a query to get a
sum of the values from that field for all records that have the desired part
number.

 

[Guest]

I do have a table for units received, but I do not have a field where the
total is calculated. I know how to build an expression, but how do I
translate that into bringing that total over. Do I need to create another
column to bring that total in?
I appreciate the help.

 

[Chandrasekar]

Hey this is working excellent. Awesome work

I do have a table for units received, but I do not have a field where the
total is calculated. I know how to build an expression, but how do I
translate that into bringing that total over. Do I need to create another
column to bring that total in?
I appreciate the help.

 

[Ken Snell \(MVP\)]

You don't need a field. What you need is a query that provides that
information for you; example:

SELECT T.PartNumberField, Sum(T.PartQuantityField)
FROM TableName AS T
GROUP BY T.PartNumberField;