Error message in report

[Guest]

SELECT OverTimebyEmp.Expr2, OverTimebyEmp.oTDLdaTE, OverTimebyEmp.oTDLOP,
OverTimebyEmp.oTDLhOURUSED, OVETTIMEUSEDOWN.oTDLhOURUSED,
OverTimebyEmp.oTBlocked, OverTimebyEmp.oVERtIMErEFUSED,
OverTimebyEmp.HrOffered, OverTimebyEmp.Whyexcused, Employees.SSI,
OverTimebyEmp.AuthorizationName
FROM OVETTIMEUSEDOWN RIGHT JOIN (OverTimebyEmp INNER JOIN Employees ON
OverTimebyEmp.SSI = Employees.SSI) ON OVETTIMEUSEDOWN.otdliD =
OverTimebyEmp.otdliD;

I get an error message in m y report. The specified field [oTDLhourused]
could refer t more than one table listed in the from clause of your sql
statement. How can I correct this, it works as a query but not in a report.

 

[Ken Snell \(MVP\)]

Sounds like the report has a control that uses a field name of
[oTDLhourused] in the expression, and the report doesn't know which query
field that means. In that control's ControlSource expression, change
[oTDLhourused] to either [OverTimebyEmp].[oTDLhOURUSED] or to
[OVETTIMEUSEDOWN].[oTDLhOURUSED], depending upon which field is the right
one to use.

It also may be in the Sorting & Grouping properties.