Foxtable(狐表)用户栏目专家坐堂 → 记录数


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

主题:记录数

帅哥,在线噢!
y2287958
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:狐神 帖子:4759 积分:34603 威望:0 精华:0 注册:2008/8/31 22:44:00
  发帖心情 Post By:2013/6/16 16:27:00 [显示全部帖子]

试试这个或者参考一下:
Dim s As String
Dim f() As String = {"接单","已派车","作业中","待收单","待结账","正结费","待确认","待审核","已审核"}
For i As Integer = 0 To f.Length-1
    Dim c As Integer = Tables("业务大表").Compute("Count([_Identify])","状态 = '" & f(i) & "'")
    If c > 0
        s += f(i) & ":" & c
    End If
Next
RibbonMenu.StatusBar.Message1 =  s

 回到顶部