Hi,
I'm having trouble getting the syntax right on below Dsum function, where I'm trying to sum the [Total Qty] if the [DateCompleted] is between two dates that I stored in a couple of TempVar variable. This is what I have so far. I have verified my TempVar variable result.
Code:intTotalAdded = DSum("[Total Qty]", "MyTable", "[DateCompleted] between #" & [TempVars]![TempBeginDate] & "# and [DateCompleted] #" & [TempVars]![TempEndDate] & "#")