DSum Syntax

D

DS

I have a DSum that is giving me problems. It says wrong synatx. Any
suggestions welcome.
Thanks
DS

Me.TxtRefAmount = Nz(DSum("PayAppliedAmount", "tblPayApplied",
"PayAppliedCheckID = " & Forms!frmFXRefunds!TxtCheckID & " And
PayAppliedNameID = " & Forms!frmFXRefundItems!TxtNameID & " And
PayAppliedAmount < 0 And PayAppliedTime = #" &
Forms!frmFXRefundItems!TxtTime & "#), 0)
 
D

DS

Now it's saying Type Mismatch....I think I'm getting closer...
DS

Me.TxtRefAmount = Nz(DSum("PayAppliedAmount", "tblPayApplied",
"PayAppliedCheckID = " & Forms!frmFXRefunds!TxtCheckID & "" _
And "PayAppliedNameID = " & Forms!frmFXRefundItems!TxtNameID & " And
PayAppliedTime = #" & Forms!frmFXRefundItems!TxtTime & "# And
PayAppliedAmount <0"), 0)
 
P

Piet Linden

Now it's saying Type Mismatch....I think I'm getting closer...
DS

Me.TxtRefAmount = Nz(DSum("PayAppliedAmount", "tblPayApplied",
"PayAppliedCheckID = " & Forms!frmFXRefunds!TxtCheckID & "" _
    And "PayAppliedNameID = " & Forms!frmFXRefundItems!TxtNameID & " And
PayAppliedTime = #" & Forms!frmFXRefundItems!TxtTime & "# And
PayAppliedAmount <0"), 0)
Click to expand...

I removed a few of the excess double quotes...
Me.TxtRefAmount = Nz(DSum("PayAppliedAmount", "tblPayApplied",
"PayAppliedCheckID = " & Forms!frmFXRefunds!TxtCheckID & " _
And [PayAppliedNameID] =" & Forms!frmFXRefundItems!TxtNameID & "
And
PayAppliedTime = #" & Forms!frmFXRefundItems!TxtTime & "# And
PayAppliedAmount <0"), 0)
 
Top