Sel ect b.学期,报名教师,Format(辅导日期,"yyyy-MM") As 月份,收费标准 * 学生数 As 应收金额,Count(b.学生编号) As 辅导学生数,Sum(IIf(b.退费金额 Is Null,交费金额,交费金额-b.退费金额)) As 实收总数,Sum(IIf(b.退费金额 Is Null,交费金额,交费金额-b.退费金额))/(收费标准 * 学生数)*100 As 百分率 From ((({缴退费信息} a Inner JOIN {辅导缴退费} b ON a.学期 = b.学期 And a.学生编号 = b.学生编号) Inner JOIN (Sel ect 学期,班级,Count(学生编号) As 学生数 From {缴退费信息} WHERE 学期 = '2017年秋季' And 缴费项目 = '学费' And 缴费状态 = '已缴'GROUP BY 学期,班级) c ON a.学期 = c.学期 And a.班级 = c.班级) Inner JOIN {奖励标准} d ON a.学期 = d.学期) Inner JOIN {收费标准} k ON Format(b.辅导日期,"yyyy-MM") = k.月份 WHERE b.学期 = '2017年秋季' And 缴费项目 = '学费' And 缴费状态 = '已缴'GROUP BY b.学期,报名教师,Format(辅导日期,"yyyy-MM"),学生数,收费标准
百分率,保留2位小数,请老师指教,谢谢!