Hi i am new to access database i am making an inventory database in which i have two tables first inventory having ID , inventory items, fields and form of inventory table too which have calculated field of current stock, in second table (Inventory Transaction) which have ID, Transaction Item, and Quantity fields. i want to calculate the current stock of specific item by using DSum function on Quantity field in which criteria should be on ID