Dim b As New SQLGroupTableBuilder("综合统计表1","人员")
b.Groups.Adddef("人员类别")
b.Totals.Adddef("人才类别",AggregateEnum.Count,"人数")
b.Totals.Addexp("性别_男","性别 = '男'")
b.Totals.Addexp("性别_女","性别 = '女'")
b.Totals.Addexp("民族_汉族","民族 = '汉族'")
b.Totals.Addexp("民族_其他","民族 <> '汉族'")
b.VerticalTotal = True
b.Build
MainTable = Tables("综合统计表1")
为什么统计出来是负值,如何改
此主题相关图片如下:1.png
![dvubb 图片点击可在新窗口打开查看](UploadFile/2016-3/2016310115873591.png)
[此贴子已经被作者于2016/3/1 0:12:42编辑过]