K
Karl
Hello,
I have two reports,
The first report (Employee Time by Date Report) shows all the hours worked
by an employee on each project. Within this report the employee field has a
header and a footer. In the header the employee's name shows up and in the
employee footer I have a field that calculates the total sum of the hours
worked(this field is labelled as Total Hours Worked)
The second report is basically the same except it only shows total
chargeable time by each employee. Similarly employee names are in the
employee header and sum of hours is in the employee footer (this calculates
the total chargeable time put in by that employee). However, on this form I
would like to also add a field that links to the [Total Hours Worked] field
in the employee footer of Report 1. I tried using query builder to enter the
following control source =Reports![Employee Time by Date Report]![Total
Hours Worked].
However, I get an error message that says #name?? . What am I doing wrong?
My hope is to divide chargeable time by total time worked to get a % of each
employees chargeable time.
thanks in advance,
I have two reports,
The first report (Employee Time by Date Report) shows all the hours worked
by an employee on each project. Within this report the employee field has a
header and a footer. In the header the employee's name shows up and in the
employee footer I have a field that calculates the total sum of the hours
worked(this field is labelled as Total Hours Worked)
The second report is basically the same except it only shows total
chargeable time by each employee. Similarly employee names are in the
employee header and sum of hours is in the employee footer (this calculates
the total chargeable time put in by that employee). However, on this form I
would like to also add a field that links to the [Total Hours Worked] field
in the employee footer of Report 1. I tried using query builder to enter the
following control source =Reports![Employee Time by Date Report]![Total
Hours Worked].
However, I get an error message that says #name?? . What am I doing wrong?
My hope is to divide chargeable time by total time worked to get a % of each
employees chargeable time.
thanks in advance,