与参数的访问报告独特的计算汇总 [英] 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屋！