View Single Post
  #1  
Old May 14th, 2010, 05:36 PM posted to microsoft.public.access.reports
C. Adamek
external usenet poster
 
Posts: 1
Default percentages calculated for a report

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?