为什么5个记录集中，有一个打不开？该怎么解决

为什么5个记录集中，有一个打不开？
Dim CUSTEMER As New ADODB.Recordset
Dim MAC As New ADODB.Recordset
Dim DATEO As New ADODB.Recordset
Dim DATEP As New ADODB.Recordset
Dim TYPES As New ADODB.Recordset

Private Sub Form_Load()
j = "结帐日期 is null"
'初始化各个组合框
querydata "select distinct(客户) from sell where " & j, CUSTEMER
querydata "select distinct(适合机型) from sell where " & j, MAC
querydata "select distinct(订货日期) from sell where " & j, DATEO
querydata "select distinct(型号) from sell where " & j, TYPES
querydata "select distinct(结帐日期) from sell " & j, DATEP
Set DataCombo1.RowSource = CUSTEMER
DataCombo1.ListField = "客户"
Set DataCombo2.RowSource = MAC
DataCombo2.ListField = "适合机型"
Set DataCombo3.RowSource = DATEO
DataCombo3.ListField = "订货日期"
Set DataCombo4.RowSource = TYPES
DataCombo4.ListField = "型号"
Set DataCombo5.RowSource = DATEP
DataCombo5.ListField = "结帐日期"
End Sub

前面4个记录集合都打开了，惟独DATEP没打开 请大家帮以下忙，鄙人多谢啦！

[解决办法]
querydata "select distinct(结帐日期) from sell " & j, DATEP 
改成
querydata "select distinct(结帐日期) from sell where " & j, DATEP