Prev: Access 2003 Report generation
Next: Calculating Readmit Rate
From: C. Adamek C. on 14 May 2010 12:36
I have a report for a query that pulls from 3 tables. The main table contains
employee hours by month and budget code. The supplemental tables contain
budget code descriptions and additional employee information.

In the code footer, I calculate the total hours by code for the year-to-date.

In the employee footer, I calculate the total hours by employee for the
year-to-date.

What I would like to add is column that shows the total hours by code as a
percent of the total hours by employee. Is this possible? If so, how do I
do it?
From: Wolfgang Kais on 20 May 2010 06:57
Hello.
C. Adamek wrote:
> I have a report for a query that pulls from 3 tables. The main table
> contains employee hours by month and budget code. The supplemental
> tables contain budget code descriptions and additional employee
> information.
> In the code footer, I calculate the total hours by code for the
> year-to-date.
> In the employee footer, I calculate the total hours by employee for the
> year-to-date.
> What I would like to add is column that shows the total hours by code
> as a percent of the total hours by employee. Is this possible? If so,
> how do I do it?

In the code footer, add a textbox, formatted as "percentage", that has a
control souce like this:
=[CodeFooterTotalTextBox]/[EmployeeFooterTotalTextBox]
(replace my names with the names of your total-textboxes)

--
Regards,
Wolfgang



 | 
Pages: 1
Prev: Access 2003 Report generation
Next: Calculating Readmit Rate