left join, then an inner join fails

[viveleroi]

I have this code, but tblFloat.Hrs pops up in a box when I run the query asking for a value... so something is wrong... any idea?

SELECT tblEmployees.FullName, tblEmployees.PTOAmount, tblEmployees.CarryOverAmount, qryEmplyeesWithUsedPTO.DateUsed, qryEmplyeesWithUsedPTO.Hrs, qryEmplyeesWithUsedPTO.WTCode, qryEmplyeesWithUsedPTO.Description, tblEmployees.Supervisor, tblEmployees.EmpID AS LanID, [tblEmployees.PTOAmount]-(Nz([tblEmployees.CarryOverAmount],0)+0)-(Nz([Hrs],0)+0) AS RemainingAmount, tblFloat.Hrs AS FloatHours
FROM (tblEmployees LEFT JOIN tblFloat ON tblEmployees.EmpID=tblFloat.EmpID) INNER JOIN qryEmplyeesWithUsedPTO ON tblEmployees.EmpID=qryEmplyeesWithUsedPTO.EmpID
ORDER BY qryEmplyeesWithUsedPTO.DateUsed;

I even tried switching the placement of the INNER JOIN and the LEFT JOIN.

 

[viveleroi]

nevermind I fixed it - somehow I had a single field name wrong.