A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

percentages calculated for a report



 
 
Thread Tools Display Modes
  #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?
  #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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.