Foxtable(狐表)用户栏目专家坐堂 → [求助]请问数字或双精度小数查找怎么写??


  共有3581人关注过本帖树形打印复制链接

主题:[求助]请问数字或双精度小数查找怎么写??

帅哥哟,离线,有人找我吗?
爱秦宣言
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:幼狐 帖子:65 积分:554 威望:0 精华:0 注册:2019/12/13 9:17:00
[求助]请问数字或双精度小数查找怎么写??  发帖心情 Post By:2020/1/3 21:49:00 [显示全部帖子]

 请问数字或双精度小数查找怎么写??请大大们来解答~~

"长度","宽度","厚度"为双精度小数,不知道怎么写了

代码如下

Dim filter As String
Dim sts() As String = {"合同号","客户名称","业务员","长度","宽度","厚度","原料产地"}
For Each st As String In sts
    Dim  val As String = e.Form.Controls(st).value
    If val > "" Then
        val = val.Replace("*","[*]")
        If filter = "" Then
            filter = st & " like '*" & val & "*'"
        Else
            filter = filter & " and " & st & " like '*" & val & "*'"
        End If
    End If
Next


Tables("销售合同基础表").Filter = filter
[此贴子已经被作者于2020/1/3 21:51:36编辑过]

 回到顶部