access 2010 vba
I'm executing an sql statement from access to update a sql server table.
The query below is an older query, but I need to be specific about which row i will be updating.
So i need a where clause added please.
The field i'm using for criteria is "proposal_id"
So i need to pass a parameter for this query in the WHERE clause.?
Can i do this within the statement below, just by adding the parameter via Access.
I need to make this an UPDATE statement ?
sQuery = "EXECUTE INSERT INTO [WORKFLOW].[dbo].[survey_results] ([RACF],[QueryDate],[ProcRun],[SearchTerm]) Values('" & racfid & "',getdate(), 2,'" & Nf1 & "');"