Unanswered: how to write this update sql statement?
I have one table with number identity, I want to set its one column value for the last row
i know i can write it with 2 seperate sql statement like this:
strSql = "select max(dealNum) from tblm_deal"
Set rscp = con.Execute(strSql)
strSql = "update tblm_deal set modelNum = 3 where dealNum = " & rscp.Fields(0)
Does anybody know how to write the sql statement in one sentence? such as
update tblm_deal set modelNum = 3 where dealNum = select max(dealNum) from tblm_deal