Adding a variable in the middle of a Query

[Nkuha]

Anyone know how to correct this code?

rst.Open "update cases SET cases.flag = 0 WHERE" & DateDiff("h", rst!datein, Now) > threshold, CurrentProject.Connection, adOpenKeyset, adLockOptimistic

 

[MattSmithProg]

Try this.

rst.Open &quot;update cases SET cases.flag = 0 WHERE &quot; & threshold < DateDiff(&quot;h&quot;, rst!datein, Now), CurrentProject.Connection, adOpenKeyset, adLockOptimistic

Note the extra space after the Where clause

 

[MattSmithProg]

Try this.

rst.Open &quot;update cases SET cases.flag = 0 WHERE &quot; & threshold < DateDiff(&quot;h&quot;, rst!datein, Now), CurrentProject.Connection, adOpenKeyset, adLockOptimistic

Note the extra space after the Where clause

No Two Nulls are the same

Matt

 

[balves]

I don't think this is going to work.

You're trying to open a recordset, rst, but you're also trying to use the recordset inside of the UPDATE statement. Which I don't think exists at that point.

Without knowing more about what you're doing, my guess is that the DateDiff should be done on a field in the Cases table.