J
JZ
My query calculates the percent of hours worked on a project compared
to total hours worked. Here are the relevant fields:
Field: HoursWorked
Table: MainProjectTable
Total: Sum
Field: SumofHoursWorked
Table: qryTtlHrs
Fieldercent: [SumOfHoursWorked1]/qryTtlHrs!SumOfHoursWorked
When I run the query I'm asked to enter parameter value for
[SumOfHoursWorked1] even though the criteria row is empty for all of
these fields. I hit OK and the query runs perfectly. How do I get rid
of the Enter Parameter Message Box? Any help would be much
appreciated. Thanks in advance.
-JZ
to total hours worked. Here are the relevant fields:
Field: HoursWorked
Table: MainProjectTable
Total: Sum
Field: SumofHoursWorked
Table: qryTtlHrs
Fieldercent: [SumOfHoursWorked1]/qryTtlHrs!SumOfHoursWorked
When I run the query I'm asked to enter parameter value for
[SumOfHoursWorked1] even though the criteria row is empty for all of
these fields. I hit OK and the query runs perfectly. How do I get rid
of the Enter Parameter Message Box? Any help would be much
appreciated. Thanks in advance.
-JZ