Dsum between dates

[pekajo]

Hi,
I am having issues with the DSum and tried different ways of putting it none worked. My latest is:

vIncAmt = DSum("[IncAmt]", "Income" And "[IncDate] between #06/03/2021# and #06/25/2021#")

This one gives me a Type mismatch.
Any ideas what I am doing wrong.
Thanks

 

[arnelgp]

this is the error, clearly seen (if income is your table):

DSum("[IncAmt]", "Income" And "[IncDate] between #06/03/2021# and #06/25/2021#")

should be:

DSum("[IncAmt]", "Income", "[IncDate] between #06/03/2021# and #06/25/2021#")

 

[oleronesoftwares]

if you want to include both dates
DSum("[IncAmt]", "Income", "[IncDate] between #06/03/2021# and #06/25/2021#")

if you want to exclude both dates
DSum("[IncAmt]", "Income", "[IncDate] > #06/03/2021# and [IncDate]<#06/25/2021#")

 

[Pat Hartman]

Probably better to not hard code the dates. Use form field references instead.