Query not pulling from Main Table

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

Guest

Hello,

I a Main form (QC) and a Subform (QCErrors) linked by Loan Number.
Everything works fine and all info is being stored in their respective
tables. However, when I try to run a query for the information, only the
records with info in both the Main form AND Subform show. If no information
is in the Subform, it doesn't show in the query. What did I do wrong?

Thanks!!
 
Here is what the query says:
SELECT tblQC.QCBy, tblQC.CurrentDate, tblQC.CIF, tblQC.LnNumber,
tblQC.LastName, tblQC.FirstName, tblQC.BatchType, tblQC.BatchName,
tblQCErrors.ProcName, tblQCErrors.ErrType, tblQCErrors.ErrOcc
FROM tblQC, tblQCErrors
ORDER BY tblQC.QCBy, tblQC.LnNumber;
 
Back
Top