View Single Post
  #2  
Old May 20th, 2010, 11:57 AM posted to microsoft.public.access.reports
Wolfgang Kais[_4_]
external usenet poster
 
Posts: 18
Default percentages calculated for a report

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