strsql = "insert into cs_his(id,cname,cbir,cwork,cdan,ctel,cliwu,cdtime,ctian) " _ & " select b.id,a.cname,a.cbir,a.cwork,a.cdan,a.ctel,b.cliwu,b.cdtime,datediff(day,getdate(),cdtime) from cs_info a right join cs_ding b on b.ctel=a.ctel where b.id=" & FrmMain.zxcv.SelectedItem.Tag在ACCESS中为什么说GETDATE函数未定义啊??? 换成 DATE()或者DATE怎么都不好用??????
& " select b.id,a.cname,a.cbir,a.cwork,a.cdan,a.ctel,b.cliwu,b.cdtime,datediff(day,getdate(),cdtime) from cs_info a right join cs_ding b on b.ctel=a.ctel where b.id=" & FrmMain.zxcv.SelectedItem.Tag在ACCESS中为什么说GETDATE函数未定义啊???
换成 DATE()或者DATE怎么都不好用??????