vb sql 字符串问题

[Y3721]

我现在有个sql字符串需要用到+1，但是在VB里总报错
Select id-(select min(id) from ldkh)+1 from ldkh
在vb里把+1作为字符串报错

[ejoe313]

dim strSql as string
strSql="Select id-(select min(id) from ldkh)+1 from ldkh "

[vansoft]

dim strSql as string
strSql="Select [id]-(select min([id]) from ldkh)+1 from ldkh "

[lafeal]

直接把id设置为Int递增量为1不行么？