快速平台通用查询窗体在筛选不为空时出现:3075语法错误 在查询表达式'([字段] Not (Is Null or [字段]=''))'中。为空时也出现错误时,
手动更改一下通用查询窗体【SysFrmGeneralQuickQuery】代码
原代码:
Case "Equal Blank"
strWhere = Me.cboField & " Is Null or " & Me.cboField & "=''"
Case "Does Not Equal Blank"
strWhere = Me.cboField & " Not (Is Null or " & Me.cboField & "='')"
修改成:
Case "Equal Blank"
strWhere = Me.cboField & " Is Null"
Case "Does Not Equal Blank"
strWhere = Me.cboField & " Is Not Null"