Can somebody post a working DSum line of code with perhaps 4 or 5 clauses in the criteria section of the function. I can't get mine to work properly:
mine:
ThanksCode:SumCondition = "[Pipeline] = '" & PipelineName + "'" + " And [LeaseOrStream] = 2 " + "And [MonthEnd] = " & myMonth MyRunningTotal = DSum("[SchedulerInputData]![DeliveredVolume]", "SchedulerInputData", SumCondition)




Reply With Quote