[已解决]SQL语句

zyz218 · 发表于 2007-10-9 20:11:21

If Me.Check1 = True Then
      STemp = "INSERT INTO lack(emid, others, yearmonth)"
      STemp = STemp & "SELECT emid," & Me.Text1 & ",'" & Me.Text3 & "'"
      STemp = STemp & "FROM lackadd"
      STemp = STemp & "WHERE intime<#" & Me.Text2 & "# and vocation='作业员';"
         DoCmd.RunSQL STemp
End If

提示FROM子句语法错误？？？

[ 本帖最后由 zyz218 于 2007-10-9 20:39 编辑 ]

zyz218 · 发表于 2007-10-9 20:39:15

If Me.Check1 = True Then
      STemp = "INSERT INTO lack(emid, others, yearmonth)"
      STemp = STemp & "SELECT emid," & Me.Text1 & ",'" & Me.Text3 & "'"
      STemp = STemp & " FROM lackadd"
      STemp = STemp & " WHERE intime<#" & Me.Text2 & "# and vocation='作业员';"
         DoCmd.RunSQL STemp
End If
FROM前面与WHERE前面留一空格问题解决！

andymark · 发表于 2007-10-9 20:42:08

STemp & " 间加空格, 在立即窗体debug.print STemp 一下
If Me.Check1 = True Then
      STemp = "INSERT INTO lack(emid, others, yearmonth)"
      STemp = STemp & " SELECT emid," & Me.Text1 & ",'" & Me.Text3 & "'"
      STemp = STemp & " FROM lackadd"
      STemp = STemp & " WHERE intime<#" & Me.Text2 & "# and vocation='作业员';"
         DoCmd.RunSQL STemp
End If

帐号		自动登录	找回密码
密码			注册

群介绍
Access培训群 (792054000)
Access免费培训2群 (163530137)
Access免费培训群 (833510950)
Access免费培训群2 (792054000)
Access交流总群 (5004108)

主题相关群

地区相关群[您还没设置居住地]

[查询] [已解决]SQL语句

群介绍
主题无相 (随机显示版	同地区群块其他地区)