与参数的访问报告独特的计算汇总 [英] Unique Calculated Totals with Parameters in Access Report
问题描述
我的工作与使用员工访问2003年的报告,他们的点,他们已经积累了一段时间。当运行报表,它要求的参数起始日期和结束日期,然后产生一个很好的报告,由主管 - >员工 - >每个点有一个原因
I'm working with an access 2003 report that uses an employee, and their points they've accumulated over a period of time. When the report is run, it asks for parameters StartDate and EndDate, then generates a nice report by Supervisor -> Employee -> Each point with a reason.
我怎样才能得到下一个总箱到每个员工的名字给总积分为每个员工?我想过写一个SELECT和WHERE语句并添加变量到VBA,所以源属性是:
How can I get a total box next to each employees name to give the total points for each employee? I've thought about writing a SELECT and WHERE statement and adding variables to the VBA, so the source property is:
=(SUM(SELECT [PointValue] WHERE [EmployeeName] = CurrentEmployee AND & _
[Date] <= #StartDate# AND [Date] >= #EndDate#))
在此先感谢!
Thanks in advance!
推荐答案
要做到这一点是使用分组最简单的方法。如果您创建了员工字段(列),一组标题,你可以在组头中添加一个文本框,总结了点。
The easiest way to do this would be to use grouping. If you create a group header for the employee field (column) you can add a textbox and sum the points in the group header.
这篇关于与参数的访问报告独特的计算汇总的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!