Using form query in report

[kronar]

I am using a query in a subform and want to us it in a subreport. table is multiple time sheets by date, subform and subreport show time accumulated by emplyee. So each time is hours summed per employee. In the report footer I want to sum all employees hours into one total. It works in the sub form but not the subreport? Any tips?
Querry used is:
SELECT J.JB_JobBidNo, J.JBT_EmpNum, E.EM_FirstName, E.EM_LastName, Sum(J.JBT_WorkHrs) AS HbE, E.EM_Wage, (Sum(J.JBT_WorkHrs)*E.EM_Wage) AS Tot
FROM EM_Emp AS E INNER JOIN JBT_EmpTime AS J ON E.EM_EmpNumber = J.JBT_EmpNum
WHERE J.JB_JobBidNo=[Forms]![frmMenu]![txtJobNum]
GROUP BY J.JB_JobBidNo, J.JBT_EmpNum, E.EM_FirstName, E.EM_LastName, E.EM_Wage
ORDER BY J.JBT_EmpNum;
The total is a text field with source of Sum(HbE), i get error? instead of the total total.

 

[dhookom]

Is the text box containing =Sum([Hbe]) in the Page or Report Footer section? Expressions like this won't work in the Page sections.

Duane
Hook'D on Access
MS Access MVP

 

[kronar]

Good call...
I just found in my book that page footers don't support agregate functions so I moved the text box to the report footer - now it WORKS...