蓝老师,如何把"档案记载_出生日期”的空值筛选掉
我写成:档案记载_出生日期 is not null,结果是错的,您帮我看看,怎么改?
Dim jb As New SQLJoinTableBuilder("出生日期查询","三龄预审表")
jb.C
jb.AddTable("三龄预审表","档案编号","人事档案基础信息","档案编号")
jb.AddCols("{三龄预审表}.档案编号", "{三龄预审表}.姓名","档案记载_类号","档案记载_出生日期 is not null","材料名称","问题种类","备注")
jb.Build()
MainTable = Tables("出生日期查询")
Tables("出生_Table1").DataSource = jb.BuildDataSource()