Value from DSUM with multiple criteria wrong

[maxmaggot]

I have a DSUM function in a report and I think I almost have it right but I just can't get the syntax exactly right. It keeps returning 0.

=Nz(DSum("[Amount]","Expenses","[Expense Type] =2" & " AND  [InvoiceDate] Between " & DateSerial(Year(Date()),1,1) & " And "  & DateSerial(Year(Date()),12,31)),0)

All fields exist as spelt and are set to the correct data types.

Any help from anyone please? Thank you.

[pbaldy]

The date values need delimiters:

http://access.mvps.org/access/general/gen0018.htm

[maxmaggot]

I've added the delimiters as follows but I'm getting an error message now

=Nz(DSum("[Amount]","Expenses","[Expense Type] =2" & " AND [InvoiceDate] Between #" & DateSerial(Year(Date()),1,1) & "# And #" & DateSerial(Year(Date()),12,31)),0) & "#"

[maxmaggot]

My mistake. fixed now. Put the last delimiter outside the DSUM. Working now with

=Nz(DSum("[Amount]","Expenses","[Expense Type] =2" & " AND [InvoiceDate] Between #" & DateSerial(Year(Date()),1,1) & "# And #" & DateSerial(Year(Date()),12,31) & "#"),0)

Thanks for your help

[pbaldy]

No problem.