有关查询的问题
我想从一个数据表中找出满足条件的记录,其条件是:1。lgqcheck字段为空
2。memberid为text1控件中所输入的数字。
我这样编写我的查询语句:
Data1.RecordSource = "select [membername],[recordtime],[workpro],[shouldscore],[gqcheck] from score where [lgqcheck]="" and [memberid] = " & 工区修改栏.Text1.Text
运行后问题出在lgqcheck为空的条件限制,但我不知道怎么更改。
我想从一个数据表中找出满足条件的记录,其条件是:1。lgqcheck字段为空
2。memberid为text1控件中所输入的数字。
我这样编写我的查询语句:
Data1.RecordSource = "select [membername],[recordtime],[workpro],[shouldscore],[gqcheck] from score where [lgqcheck]="" and [memberid] = " & 工区修改栏.Text1.Text
运行后问题出在lgqcheck为空的条件限制,但我不知道怎么更改。
Data1.RecordSource = "select [membername],[recordtime],[workpro],[shouldscore],[gqcheck] from score where [lgqcheck]="""" and [memberid] = " & 工区修改栏.Text1.Text
Data1.RecordSource = "select [membername],[recordtime],[workpro],[shouldscore],[gqcheck] from score where iif(isnull([lgqcheck]),"""",[lgqcheck])="""" and [memberid] = " & 工区修改栏.Text1.Text'SQL数据库
Data1.RecordSource = "select [membername],[recordtime],[workpro],[shouldscore],[gqcheck] from score where isnull([lgqcheck],'')='' and [memberid] = " & 工区修改栏.Text1.Text