D
D Witherspoon
WorkLogID is Primary Key
This DOESN'T WORK! (Operation must use an updateable query)
---------------
UPDATE tblWorkLog wl1 SET DueDate = (Select Now() as field1 from tblWorkLog
wl2 where wl1.WorkLogID=wl2.WorkLogID)
This DOES WORK
-------------------
UPDATE tblWorkLog wl1 SET DueDate = Now()
The update query I am trying to write has to pull a value from another
table/query and I get the same error. For simplicity I wanted to show that
not even selecting Now() from the same table as a correlated subquery gives
me the same error.
MS Access is so irritating...
This DOESN'T WORK! (Operation must use an updateable query)
---------------
UPDATE tblWorkLog wl1 SET DueDate = (Select Now() as field1 from tblWorkLog
wl2 where wl1.WorkLogID=wl2.WorkLogID)
This DOES WORK
-------------------
UPDATE tblWorkLog wl1 SET DueDate = Now()
The update query I am trying to write has to pull a value from another
table/query and I get the same error. For simplicity I wanted to show that
not even selecting Now() from the same table as a correlated subquery gives
me the same error.
MS Access is so irritating...