此主题相关图片如下:qq截图20171012100408.png
![dvubb 图片点击可在新窗口打开查看](UploadFile/2017-10/20171012105757283.png)
t.Fill("Select a.学期,报名教师,Format(缴费日期,"yyyy-MM") As 月份,Count(学生编号) As 学生数,Sum(IIf(退费金额 Is Null,缴费金额,缴费金额-退费金额)) As 实收总数,Sum(IIf(退费金额 Is Null,缴费金额,缴费金额-退费金额)) * 教师奖励百分率/100 As 奖励金额 Fr om {辅导班收费} a Inner JOIN {辅导教师工资} b ON a.学期 = b.学期 WHERE a.学期 = '2017年秋季' GROUP BY a.学期,报名教师,Format(缴费日期,"yyyy-MM"),教师奖励百分率","数据库",True)
此主题相关图片如下:qq截图20171012100321.png
![dvubb 图片点击可在新窗口打开查看](UploadFile/2017-10/201710121053937950.png)
在SQL查询表测试是可以,在窗口Table1出现错误,请指教