DSum Problem

[DS]

I think it's the Syntax but it's not returning a value. It might be the
DATE part. Any help appreciated.
Thanks
DS


Me.TxtDrops = Nz(DSum("DropAmount", "tblDrops", "DropEmpID = " &
Me.TxtDriverID & " And DropDate = Date"), 0)

 

[Jeff L]

Me.TxtDrops = Nz(DSum("DropAmount", "tblDrops", "DropEmpID = " &
Me.TxtDriverID & " And DropDate = '" & Date & "'"), 0)

Hope that helps!

 

[DS]

Me.TxtDrops = Nz(DSum("DropAmount", "tblDrops", "DropEmpID = " &
Me.TxtDriverID & " And DropDate = '" & Date & "'"), 0)

Hope that helps!

Thanks it did help, this actually worked.

DS
Me.TxtDrops = Nz(DSum("DropAmount", "tblDrops", "DropEmpID = " &
Me.TxtDriverID & " And DropDate = #" & Date & "#"), 0)