Good morning,
I am trying to sum the amount after December 31, 2019 and a date selected on a form. I am not getting an error message, the result is just blank.
Where am I going wrong?
I am trying to sum the amount after December 31, 2019 and a date selected on a form. I am not getting an error message, the result is just blank.
Code:
=DSum("[Amount]","qryStatement2","[TransactionDate] > #31-12-19# and [TransactionDate]<#" & [txtLastStatement] & "# AND [AccountName]='" & [AccountName] & "'")
Where am I going wrong?