Trouble with DSum in a Query 1

[djmurphy58]

Novice user here.

Having trouble getting DSUM to work in a query. My expression is:

DSum(&quot;[CostCodeQuantity]&quot;,&quot;tblDailyBudgetIntermediateTable&quot;,&quot;[Date]<=&quot; & [Date])

The problem is that when I run the query, nothing shows up in this new field.

What did I do wrong? My field &quot;CostCodeQuantity&quot; comes from tblDailyBudgetIntermediateTable and the field &quot;Date&quot; comes from another table called tblDailyBudget.

Did I write the expression incorrectly??

Thank you,
Dennis

 

[djmurphy58]

Ok JonFer- I think everything is working as it should right now.
You were a huge help. I cannot thank you enough!!!

Thanks,
Dennis