标题: 类型不匹配错误 [打印本页] 作者: ▇▇▇▇▇▇▇ 时间: 2014-6-4 10:37 标题: 类型不匹配错误 Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim Sql As String
Set db = CurrentDb()
Sql = "Select Right([ZFBH],3) AS XXH,Left([ZFBH],InStrRev([ZFBH]," - ")) AS DM From ZFB where DM = '" & Forms!HTZF!DM & "'"
请大家帮我看看你这句话哪里错误,提示 运行时错误“13”,类型不匹配,感激不尽1作者: access学习交流 时间: 2014-6-4 17:52
上传附件吧,这样谁知道问题啊,如果是类型问题的话,一般都是由于数字类型引起的。 '" & Forms!HTZF!DM & "'" 把后面的单引号去掉吧 " & Forms!HTZF!DM & ""