G
Guest
I have a report that pulls from a query that contains a portion of salary
data. From a table that contains all salry data, I have queried only the pay
types from each employee that I am interested in.
In the report, I have added a text box that calulates each employees total
pay for the quarter, a text box that expresses as a percentage each employees
total pay by the grand total of all employees' pay, and a text box that
multiplies their percentage by another text box that contains an inputted
amount.
In the report footer section I would like to total all of the percentages
(the total should equal 100%) and I would like to total the boxes of each
employees' percentage times the inputted value (the total should equal the
inputted value).
I can't seem to get the totals to work in the report footer section.
Any ideas?
data. From a table that contains all salry data, I have queried only the pay
types from each employee that I am interested in.
In the report, I have added a text box that calulates each employees total
pay for the quarter, a text box that expresses as a percentage each employees
total pay by the grand total of all employees' pay, and a text box that
multiplies their percentage by another text box that contains an inputted
amount.
In the report footer section I would like to total all of the percentages
(the total should equal 100%) and I would like to total the boxes of each
employees' percentage times the inputted value (the total should equal the
inputted value).
I can't seem to get the totals to work in the report footer section.
Any ideas?