If zuixnl <> "" AndAlso zuidnl <> "" AndAlso tadxlcb <> "" AndAlso hunyzk <> "" Then
drs = DataTables("会员资料").SQLSelect("[性别] = '女' And [年龄] >= '" & zuixnl & "' and [年龄] <= '" & zuidnl & "' and ([学历] = '" & tadxl1 & "' or [学历] = '" & tadxl2 & "') and [婚姻状况] <= '" & hunyzk & "'",4,"[会员行为_发起编号] DESC") '从订单表找,个人订单集合
Else
drs = DataTables("会员资料").SQLSelect("[性别] = '女'",4,"会员编号 DESC") '从订单表找,个人订单集合
End If
测试发现可以正常执行,是编号desc哪里,列名写错了
[此贴子已经被作者于2017/4/20 10:24:01编辑过]