You do not need to use the DSUM method. Using two queries will give you the required result. The first query totals the depreciation for each year with an <=[Enter Fiscal Year] in the criterai for the Fiscal year. This will give you the total for each store for the Fiscal Year(s) <= to the year entered. Now in the second query add the NBV table fields store and the first query then link the store in the table and query. Also put [Enter Store] in the criteria for the store. To obtain the result deduct the total from the total in query 1 from the NBV.