How to carry new totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a databse created already. I need to carry over new totals after items
have been shipped.
 
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.
 
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.
 
Hey this is working excellent. Awesome work


Thomas said:
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.
Click to expand...
 
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;
 
Back
Top