updating a value on a table from a field 2... 1

[wshs]

similar question as the first but..

CurrentProject.Connection.Execute _
"Update tbl_psc " & "SET contractamt = contractamt + " & Me.txtContAmt & " WHERE contractno='" & Me.txtContNum & "' AND Addconno=" & Me.txtAddContNum & "'"

can this not work?
i want access to look up both contractno and addconno to add contract amt since a record can have same contractno but different addconno...

 

[PHV]

Either this:
"Update tbl_psc " & "SET contractamt = contractamt + " & Me.txtContAmt & " WHERE contractno='" & Me.txtContNum & "' AND Addconno=[!]'[/]" & Me.txtAddContNum & "'"
Or this:
"Update tbl_psc " & "SET contractamt = contractamt + " & Me.txtContAmt & " WHERE contractno='" & Me.txtContNum & "' AND Addconno=" & Me.txtAddContNum

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PHV]

OOps, sorry for the typo.
Either this:
"Update tbl_psc " & "SET contractamt = contractamt + " & Me.txtContAmt & " WHERE contractno='" & Me.txtContNum & "' AND Addconno=[!]'[/!]" & Me.txtAddContNum & "'"
Or this:
"Update tbl_psc " & "SET contractamt = contractamt + " & Me.txtContAmt & " WHERE contractno='" & Me.txtContNum & "' AND Addconno=" & Me.txtAddContNum

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wshs]

thank you! that works!

 

[PHV]

that works
Which ?

 

[wshs]

this one

"Update tbl_psc " & "SET contractamt = contractamt + " & Me.txtContAmt & " WHERE contractno='" & Me.txtContNum & "' AND Addconno=" & Me.txtAddContNum