Blank field from second query table

[kmsacca]

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?

 

[AUGuy]

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?

How are your two tables related to each other? Do you have an employee# (or some other identifying field) that links the 'laborused' and 'personnel' tables?

A little more information on your database would greatly help diagnose the problem.

Guy

 

[kmsacca]

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

 

[AUGuy]

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

Could you post the SQL statement for your query? To do this, open your query in design view, then change it to SQL View.

 

[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;

 

[AUGuy]

SQL looks good... My guess is you've got a problem with your Employee names on the Personnel table. If you'd like to upload the database I can take a closer look. I'm no expert like a lot of the guys around here, but there seems to be something basic missing somewhere.