[RESOLVED] is there an "update-select statement"?

[jeanette_db]

i want to update a field in a certain table....

here's my code:

Set Rs = con.Execute("select * from t_taxrate") 
    Do While Rs.EOF <> True
        con.Execute "update A13029t set nature = '" & Rs!nature & "' where atc_code = '" & Rs!atc_code & "'"
        Rs.MoveNext
    Loop

i want to lessen the number of lines in the program... "do while loop" may take some time... is there an "update-select statement"?
if there is, what's its syntax?

thanks in advance....

[noielen]

visit this link

[jeanette_db]

visit this link

eyh thanks! Got it... =)