![](images/userface/image1.gif)
加好友 发短信
等级:五尾狐
帖子:1152
积分:7712
威望:0
精华:0
注册:2019/6/13 9:57:00
|
如何按周或日统计 Post By:2022/6/2 17:41:00 [只看该作者]
下面代码是月度统计 Dim b As New GroupTableBuilder("统计表1",DataTables("订单")) b.Groups.AddDef("日期","月份") 'b.Totals.AddDef("数量") ' b.Totals.AddDef("金额") ' b.Build 'MainTable = Tables("统计表1") '
按周统计,下面代码,没报错,也没执行,请老师纠正,谢谢 Dim b As New GroupTableBuilder("统计表1",DataTables("订单")) b.Groups.AddDef("日期","周") 'b.Totals.AddDef("数量") ' b.Totals.AddDef("金额") ' b.Build 'MainTable = Tables("统计表1") '
按日统计
Dim b As New GroupTableBuilder("统计表1",DataTables("订单")) b.Groups.AddDef("日期","日") 'b.Totals.AddDef("数量") ' b.Totals.AddDef("金额") ' b.Build 'MainTable = Tables("统计表1") '
|
|