<div>
The actual criteria is...&quot;[ReceiveDate] &lt;= #&quot; &amp;&nbsp;[ReceiveDate] &amp;&nbsp;&quot;#&quot;<br />
PS. &nbsp;You had left off the closing quote after the last # sign. &nbsp;Thanks for the help.<br />
&nbsp;
</div>


The actual criteria is..."[ReceiveDate] <= #" & [ReceiveDate] & "#"
PS.  You had left off the closing quote after the last # sign.  Thanks for the help.
 

<div>
<div class="content wysiwyg-content">
After 2 hours of attempting to get the Dsum function to create a running total, I am turning to EE.<br />
<br />
The below SQL results in a null value in the running total column. &nbsp;If I remove the criteria from the DSum function, I receive a total, but not a running total. &nbsp;With that said, I obviously have an error in criteria syntax.<br />
<br />
SELECT qryProgress_Receive_SJ_Bar<wbr />e.ReceiveD<wbr />ate, qryProgress_Receive_SJ_Bar<wbr />e.[Bare DRL Unloaded], DSum(&quot;[Bare DRL Unloaded]&quot;,&quot;qryProgress_Re<wbr />ceive_SJ_B<wbr />are&quot;,&quot;[Rec<wbr />eiveDate] &lt;=&quot; &amp;&nbsp;[ReceiveDate] &amp;&nbsp;&quot;&quot;) AS [Total Bare DRL Unloaded]<br />
FROM qryProgress_Receive_SJ_Bar<wbr />e;
</div>
</div>


After 2 hours of attempting to get the Dsum function to create a running total, I am turning to EE.

The below SQL results in a null value in the running total column.  If I remove the criteria from the DSum function, I receive a total, but not a running total.  With that said, I obviously have an error in criteria syntax.

SELECT qryProgress_Receive_SJ_Bare.ReceiveDate, qryProgress_Receive_SJ_Bare.[Bare DRL Unloaded], DSum("[Bare DRL Unloaded]","qryProgress_Receive_SJ_Bare","[ReceiveDate] <=" & [ReceiveDate] & "") AS [Total Bare DRL Unloaded]
FROM qryProgress_Receive_SJ_Bare;

DSum Running Total Date Criteria

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.