DSUM Syntax with dates

[LonghronJ]

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.

intTotalAdded = DSum("[Total Qty]", "MyTable", "[DateCompleted] between #" & [TempVars]![TempBeginDate] & "# and [DateCompleted] #" & [TempVars]![TempEndDate] & "#")

[pbaldy]

Don't repeat the field name with Between.

"[DateCompleted] between #" & [TempVars]![TempBeginDate] & "# and #" & [TempVars]![TempEndDate] & "#"

[LonghronJ]

Works great. Thanks.

[pbaldy]

Happy to help!