参考:http://www.foxtable.com/webhelp/scr/2720.htmDim g As New CrossTableBuilder("统计表1", DataTables("AccountVouchersDetails"))
g.HGroups.AddDef("Account")
g.VGroups.AddDef("BillType")
g.Totals.AddDef("Money", "Money")
g.Decimals = 2
Dim y As Integer = 2017 '指定年份
Dim dt1 As New Date(y, 1, 1)
Dim dt2 As New Date(y, 12, 31)
Dim Filter As String
Filter = "日期 >= #" & dt1 & "# And 日期 <= #" & dt2 & "#"
g.Filter = Filter
……