parameter prompt on multi-table querry

[kronar]

I am trying to display the total hours by employee by job number.

I have a subreport based on a subquery - selected by job number, grouped by EmpNum.

Have one column 'HrsbyEmp:JBT_WorkHrs' Summed.

In a later column I want to display the total for each Emp_Num
coded 'TotbyEmp:[HrsbyEmp]*[EM_Wage]'.

Each time it runs, I get a prompt box 'Enter parameter Value' 'HrsbyEmp'

How can I get ride of this prompt?

 

[StuckInTheMiddle]

Not much information here, but it appears that 'HrsbyEmp' is your table?

A,

 

[kronar]

Tables are JB_Jobs indexed by JB_JobBidNo
JBT_EmpTime
EM_Emp indexed by JBT_EmpNumber

Query is on JBT_EmpTime by JB_JobBidNo one row for the grouping of all JBT_EmpTime records for each Employee.

so HrsbyEmp is the column name grouped by JBT_EmpNumber

 

[StuckInTheMiddle]

Ok, what happens if you replace 'TotbyEmp:[HrsbyEmp]*[EM_Wage]' with 'TotbyEmp:[JBT_WorkHrs]*[EM_Wage]' ?

A,

 

[kronar]

As the query groups JBT_ time records by employee number for this job, I need the summed group HrsbyEmp to be multiplied by the emp wage. (I think)