Stock transactions

[g18c]

Hi, from the sample ms database i have a stock transaction database for
my products.

There are columns to Receive, Use and Shrink stock. From the goods
received, used and adjustments (shrinkage) i can calculate the stock
level. Each transaction also has a location (incase stock exists in a
number of places in the factory). There can be many transactions, for
different locations, for one particular product (hence a one to many
relationship between my StockItem and StockTransactions tables).

What i would like to do is write a query to sum the stock for each
discreet location, but im stuck! From that query i can then sum the
total stock for a particulate product.

Any pointers much appreciated.

Cheers,

Chris

 

[[MVP] S.Clark]

Select DiscreetLocation, PartNo, Sum(Qty) from Tablename Group By
DiscreetLocation, PartNo


--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html