DSum Running Total Date Criteria
Posted on 2009-04-18
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]