DSUM with DLOOKUP

[maxmaggot]

I've been trying to remove the need for a query to calcuate a sum for me and I;ve had a go with DSUM. I'm getting a #Type error. I'm trying to get the yeat to date total for an amount. Here is the code I've written.



=DSum("[Amount]","[Donations]") & DLookUp(DatePart("yyyy","[DatePaid]"),"[Donations]",DatePart("yyyy",Date()))

I've also tried

=DSum("[Amount]","[Donations]"), "Don_Amount=" & DLookUp(DatePart("yyyy",[DatePaid]),[Donations],DatePart("yyyy",Date())

Thanks for your time

[maxmaggot]

Got it with
=DSum("[Amount]","Donations","[DatePaid] BETWEEN #" & DateSerial(Year(Date()),1,1) & "# AND #" & Date() & "#")