DSUM Function Parameters from Multiple Tables / Domains

[bs0d]

I have this function to show a running total through time for a specific id:

Data_CUM: DSum("Sales","tblDailySales","[Item_KEY]=" & [Item_KEY] & " And [ReadingDate]<=#" & [ReadingDate] & "#")

How might I modify this to instead show the running total of a group of items that share a common group name from another table? Say the table was "tblItemProperties" and the desired field is "exampleGroup" ? (There would be an INNER JOIN on Item_KEY)

Finally, I'd also like to see how it would look if I needed to expand that more to those items that match an "exampleGroup" and "exampleSubGroup".

Thanks!

 

[bs0d]

I'm reading here: DSum using criteria from multiple, related tables - Microsoft Community that you may be able to use dLookup in conjunction with DSUM to get what you're after. I'm trying some examples - no errors, but it doesn't seem to be producing the correct results. Here's what I have so far:

Data_CUM: DSum("Sales","tblDailySales","ReadingDate <=#" & [ReadingDate] & "# AND [Item_KEY]=" & DLookUp("[KEY_ID]","tblItemProperties","[exampleGroup] ='My_Group"))

 

[bs0d]

What I've decided to do is break it up into two queries:

1 - a make table query to have a running total by date per item.

2 - run a query on the new table that sum's the sums of items by date.