Sum calculation with Quety

[oquinnc]

Based on the structure below, how do you go about calculating the 'Requsted Inventory Sum' for each product for a particular Company.

Table: Company
Company Name (relates to same field in 'Products')
Original Inventory
Requested Inventory Sum
Remaining Inventory

Table: Products (Displayed as Subform on 'Company')
Company Name (relates to same field in 'Company Name')
Product (look up on Product Names: Products)
Requested Inventory

Table: Product Names
Products

 

[jdegeorge]

oquinnc

Do you have the Northwind database installed on your PC? It has a nice example of form/sub form with summaries.

Jim

"Get it right the first time, that's the main thing..."