DSum Problem

D

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)
 
J

Jeff L

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

Hope that helps!
 
D

DS

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

Hope that helps!
Click to expand...
Thanks it did help, this actually worked.

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