“********
”，意思是户类型=**户，危房户=是，但****
类型为空
[此贴子已经被作者于2024/2/26 14:35:06编辑过]
Filter = "户类型 = 脱贫户 And 危房户 = 是 And 易返贫致贫户监测对象类型 Is null"
Cannot find column [脱贫户].
请指点
参考：
http://www.foxtable.com/webhelp/topics/1284.htm
Filter = "户类型 = '脱贫户' And 危房户 = '是' And 易返贫致贫户监测对象类型 Is null"
如图，表A的脱贫户、危房户列，表B的易返贫致贫户监测对象类型列
Filter = table（表A）."户类型 = '脱贫户' And 危房户 = '是' And table（表B）.易返贫致贫户监测对象类型 Is null"？
[此贴子已经被作者于2024/2/27 8:11:52编辑过]
要对哪个表做筛选？2个表数据通过什么列进行关联的？
Dim Filter As String
If e.Form.Controls("RadioButton1").Checked Then
Filter = "户类型 = '脱贫户' And 危房户 = '是' And 易返贫致贫户监测对象类型 Is null"
End If
ElseIf *****
Filter = *****
End If
If Filter > "" Then
Tables("户信息总表").Filter = Filter
End If
户信息总表太长，我想在查询第一个条件后，只显示某几列怎么改？{"序号", "姓名"， "身份证号"，"户类型", "危房户", "易返贫致贫户监测对象类型"}