标题: 类型不匹配错误 [打印本页] 作者: ▇▇▇▇▇▇▇ 时间: 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 & ""