DSUM Where Expression not working

[GraeagleBill]

I have a text box whose control source is =fnIncome(). Under certain conditions, the DSUM function used in the fnIncome function is to be limited to entries for the previous year only. Here is a screen-shot of what I'm seeing in Debug: (PrevYrInc is True)





Now, notice the Income values in the Ledger table for the 1st DSUM executed that returned NULL but should have returned the sum for 2014.



What am I missing?

[ssanfu]

You might try adding the date delimiters (#).

WhereExp = WhereExp & " [DOE] >=#" & LastJan1 & "# AND [DOE] <= #" & LastDec31 & "#"

[June7]

Or:

" [DOE] BETWEEN #" & LastJan1 & "# AND #" & LastDec31 & "#"

[GraeagleBill]

The "#" delimiter was all that was needed. (I liked June's reply as well, but didn't see it until later.)



Click on the heading and Viola



Thanks,
Bill