Sum on Quantity added since last date?

[mrmims]

Hello,

I have two tables. First is "TBL_Inventory_Count" and second "TBL_Inventory"

In TBL_Inventory_Count I have a "CountDate".

In TBL_Inventory I have "AddDate" and "QuantityReceived"

I want to run a query which will sum the multiple "QuantityReceived" of a record which has been added to "TBL_Inventory" since the last Inventory "CountDate".

Sum of QuantityReceived since Max([TBL_Iventory_Count].[CountDate])

I feel like I am fairly adept at Access, but for the love all things holy I am drawing a complete blank.

Thank you for any all help!

[June7]

Yes, this might not be simple.

Could have user select the last inventory date in a combobox and reference that value as filter criteria parameter in a query. That's the easy way.

If you want a query to find the last inventory date, that gets complicated. Probably involve subquery or domain aggregate functions.