plz help me

cn.Execute "update ctm set id=(id+1)where  id =" & Val(Text1.Text)

he is work but

i need use

cn.Execute "update ctm set id=(id+1)where  id =" & Val(Text1.Text) and  id=(id)where id < " & val(text1.text)"

how use the update in ...

update the ctm table

set

the id field id add one

if id = text1.text

and donot add one if the id < text1.text

plz help me

i wait the reply

bye