Selasa, 26 Mei 2015

[MS_AccessPros] Summary Page on Reports

 

Hello all,

In an effort to unify some report summaries, I have discovered that the current process we have for summary pages on the Report Footers are not very efficient. There are not a lot of reports with this summary information but each time we get a new department, I cringe.

So right now we have on the report footer a series of labels and associated text boxes they go like below as samples. There are close to 35 as of today because of the new departments added recently.

HVAC Services    =Sum(Abs([HR_HOME_DEPARTMENT_CODE]="D0802"))
Central Plant        =Sum(Abs([HR_HOME_DEPARTMENT_CODE]="D0803"))


I was wondering what others are doing to fulfill this summary on a report? Is there a more efficient way of doing a summary? Each report has a different source because of the parameters needed for each.

Thank You

 
Jim Wagner

__._,_.___

Posted by: Jim Wagner <luvmymelody@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar