Using Docmd.RunSQL to update data
Posted on 2008-06-15
I am trying to do the following:
Update Table TMain to set PendingTX in Table TMain to True when PendingTx is False, Ordered is Null Hold=False and Date()-DateEnter >89. DateEnter, Hold, Ordered, and PendingTx are all in Table TMain.
Here is my syntax but it is not correct.
DoCmd.RunSQL "UPDATE TMain SET TMain.[PendingRx] = True _
Where (TMain.PendingTx=False AND TMain.Ordered Is Null AND TMain.Hold=False AND (Date()-TMain.DateEnter>89)"
Where is my error to get this to execute correctly?