Reporting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that someone else wrote and I'm trying to update the
report. I can't get the information I've added to be displayed in the
report. I've added my information to the queries and it still leaves it all
out. I've been working on this for the last couple months and can't it
right...Any information would be appreciated.
 
We can not see what you have accomplished in the last couple months.

Why not post your query SQL?
 
Thanks Karl,

SELECT tblEmpInfo.*, tblSafety.*, tblQuantity.*, tblQuality.*,
tblJobKnowledge.*, tblSupervisorySkills.*, tblOverall.*, tblOtherInterests.*,
tblCommunication.*, tblProblemSolving.*, tblJudgment.*, tblCooperation.*,
tblDependability.*, tblJobKnowledge.*
FROM (((((((((((tblEmpInfo INNER JOIN tblJobKnowledge ON
tblEmpInfo.EmployeeID = tblJobKnowledge.EmployeeID) LEFT JOIN
tblOtherInterests ON tblEmpInfo.EmployeeID = tblOtherInterests.EmployeeID)
INNER JOIN tblOverall ON tblEmpInfo.EmployeeID = tblOverall.EmployeeID) INNER
JOIN tblQuality ON tblEmpInfo.EmployeeID = tblQuality.EmployeeID) INNER JOIN
tblQuantity ON tblEmpInfo.EmployeeID = tblQuantity.EmployeeID) INNER JOIN
tblSafety ON tblEmpInfo.EmployeeID = tblSafety.EmployeeID) LEFT JOIN
tblSupervisorySkills ON tblEmpInfo.EmployeeID =
tblSupervisorySkills.EmployeeID) INNER JOIN tblCommunication ON
tblEmpInfo.EmployeeID = tblCommunication.EmployeeID) INNER JOIN
tblCooperation ON tblEmpInfo.EmployeeID = tblCooperation.EmployeeID) INNER
JOIN tblDependability ON tblEmpInfo.EmployeeID = tblDependability.EmployeeID)
INNER JOIN tblJudgment ON tblEmpInfo.EmployeeID = tblJudgment.EmployeeID)
INNER JOIN tblProblemSolving ON tblEmpInfo.EmployeeID =
tblProblemSolving.EmployeeID;
 
You need to use left joins on your tables. If you do not have a matching
record in an inner join you will not pull any records. Also you had
tblJobKnowledge twice in the select.
Try this ---
SELECT tblEmpInfo.*, tblSafety.*, tblQuantity.*, tblQuality.*,
tblJobKnowledge.*, tblSupervisorySkills.*, tblOverall.*, tblOtherInterests.*,
tblCommunication.*, tblProblemSolving.*, tblJudgment.*, tblCooperation.*,
tblDependability.*
FROM (((((((((((tblEmpInfo LEFT JOIN tblJobKnowledge ON
tblEmpInfo.EmployeeID = tblJobKnowledge.EmployeeID) LEFT JOIN
tblOtherInterests ON tblEmpInfo.EmployeeID = tblOtherInterests.EmployeeID)
LEFT JOIN tblOverall ON tblEmpInfo.EmployeeID = tblOverall.EmployeeID) LEFT
JOIN tblQuality ON tblEmpInfo.EmployeeID = tblQuality.EmployeeID) LEFT JOIN
tblQuantity ON tblEmpInfo.EmployeeID = tblQuantity.EmployeeID) LEFT JOIN
tblSafety ON tblEmpInfo.EmployeeID = tblSafety.EmployeeID) LEFT JOIN
tblSupervisorySkills ON tblEmpInfo.EmployeeID =
tblSupervisorySkills.EmployeeID) LEFT JOIN tblCommunication ON
tblEmpInfo.EmployeeID = tblCommunication.EmployeeID) LEFT JOIN tblCooperation
ON tblEmpInfo.EmployeeID = tblCooperation.EmployeeID) LEFT JOIN
tblDependability ON tblEmpInfo.EmployeeID = tblDependability.EmployeeID) LEFT
JOIN tblJudgment ON tblEmpInfo.EmployeeID = tblJudgment.EmployeeID) LEFT JOIN
tblProblemSolving ON tblEmpInfo.EmployeeID = tblProblemSolving.EmployeeID;
 
Back
Top