Recent content by kmsacca

SELECT Personnel.HourlyRegular, LaborforWR.LaborTxID, LaborforWR.WRID, LaborforWR.WorkDate, LaborforWR.Personnel, LaborforWR.RegularHours, LaborforWR.OT, LaborforWR.Double FROM Personnel LEFT JOIN LaborforWR ON Personnel.[LastNameFirstName] = LaborforWR.Personnel;

Primary key field in personnel (lastnamefirstname)= indexed field in laborused (personnel)

I have two tables, laborused and personnel. A query on all fields in LU and only the hourly rate from P returns all the correct records, but no data in the hourly rate field. What am I missing?